Importing the data with Oracle

You can import sample data in order to validate your configuration or for training purposes. Use the Data Pump Import tool for this.

Procedure

  1. If the folder C:\oracle\admin\ISH\dpdump\ does not exist on the server, create it now.
  2. Copy PACKAGEROOT\Database\InfoShareCM\Common\Oracle\impdp\impdp.par (where PACKAGEROOT is the root folder of your package) to the folder C:\oracle\admin\ISH\dpdump\, and make sure the file is writable.
  3. Check the paths, commands, usernames and passwords in the file. The examples in the file are Windows-specific. Open the file in a plain-text editor and change the example values as needed, especially the name of the export file (DUMPFILE parameter) and the designated schema owner (SCHEMAS parameter), to match your environment.
  4. Open a command shell for your operating system.
  5. On the command prompt, define the following environment variables, with the following values:
    Environmet variableValue
    ORACLE_SIDISH
    ORACLE_HOMEthe full path of the location where you copied the application
  6. Start SQLPlus by entering the following on the command prompt: sqlplus SYS AS SYSDBA
  7. Make sure the ISOURCE user has read and write access to the folder:
    GRANT read, write ON DIRECTORY data_pump_dir TO isource;
  8. 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';
  9. Exit SQLPlus, so you are back at the command prompt.
  10. Perform the import by executing the following command:
    impdp isource parfile="C:\oracle\admin\ISH\dpdump\impdp.par"