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
- If the folder C:\oracle\admin\ISH\dpdump\ does not exist on the server, create it now.
- 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.
- 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 (
DUMPFILEparameter) and the designated schema owner (SCHEMASparameter), to match your environment. - Open a command shell for your operating system.
- On the command prompt, define the following environment variables, with the following values:
Environmet variable Value ORACLE_SIDISHORACLE_HOMEthe full path of the location where you copied the application - Start SQLPlus by entering the following on the command prompt:
sqlplus SYS AS SYSDBA - Make sure the
ISOURCEuser has read and write access to the folder:GRANT read, write ON DIRECTORY data_pump_dir TO isource; - 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'; - Exit SQLPlus, so you are back at the command prompt.
- Perform the import by executing the following command:
impdp isource parfile="C:\oracle\admin\ISH\dpdump\impdp.par"