Documentation Center

Exporting for an Oracle 12 import

Exporting the database when planning to import it back in Oracle 12 requires the use of the expdp command.

Procedure

  1. Copy the file expdp.par from C:\IShCD\yyyymmdd.CD.InfoShare<version_num>.ProjectName.IT\Database\Dump\Oracle\expdp to the dump directory (DATA_PUMP_DIR) on the database server.
  2. Goto the database server.
  3. Adapt the file names for the DUMPFILE and LOGFILE in the expdp.par file.
  4. Open a Command Prompt and set the following variables:

    Set ORACLE_SID=ISH

    Set ORACLE_HOME depending on your Oracle version:

    Oracle 11set ORACLE_HOME=c:\oracle\product\11.2.0\dbhome_1
    Oracle 12set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1
  5. Start sqlplus as sysdba
  6. Check if there is a dump directory "DATA_PUMP_DIR"
    SELECT directory_path FROM dba_directories WHERE directory_name ='DATA_PUMP_DIR';
  7. Make sure the dedicated isource database user has read and write access to the directory
    GRANT read, write ON DIRECTORY data_pump_dir TO isource;
  8. Exit SQLPlus, so you are back at the command prompt.
  9. Execute the following command
    expdp parfile="C:\Oracle\admin\<DatabaseName>\dpdump\expdp.par"
  10. Provide the user name and password for the dedicated isource database user.
    The dump file is exported in the dump directory, you can import it back after you have uninstalled the old version of Content Manager.