Documentation Center

Importing the data with Oracle

Import the sample data either for validating the configuration or for training purposes. This action follows different paths depending on the Oracle version you are using.

About this task

The use of Data Pump Import (impdp) is recommended. First you grant the ISOURCE user write permissions, then you proceed to the import.

Procedure

  1. If the folder C:\oracle\admin\ISH\dpdump on the server does not exist, create it now.
  2. Copy CD_Package\Database\Dump\Oracle\impdp\impdp.par (where CD_Package is the root folder of the CD package) to the folder C:\oracle\admin\ISH\dpdump and make sure the file is writable.

    The examples are specific for Windows. Be sure to modify the paths, commands and username/passwords to match your environment.

  3. Open C:\oracle\admin\ISH\dpdump\impddp.par in Notepad and adapt the name of the export file (DUMPFILE parameter) and, if needed, the designated schema owner (SCHEMAS parameter).
  4. Open a command prompt
  5. Set ORACLE_SID=ISH
  6. Set ORACLE_HOME=C:\Oracle\product\12.1.0\dbhome_1
  7. Start SQLPlus: sqlplus SYS AS SYSDBA
  8. Make sure the ISOURCE user has read and write access to the folder:
    GRANT read, write ON DIRECTORY data_pump_dir TO isource;
  9. Make sure the file from the Data Pump Export is copied to the DATA_PUMP_DIR:
    SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR';
  10. Exit SQLPlus, so you are back at the command prompt.
  11. For the import, execute the following command:
    impdp isource parfile="C:\oracle\admin\ISH\dpdump\impdp.par"