Importing Dump File in Oracle User

The Oracle dump file must be imported into the Oracle schema by using the impdp command.

Use the following command to import the dump file.

impdp SPEND_DBA/SPEND_DBA@ SPEND102 directory=dump
dumpfile=SPEND_SIKA_COGNOS_20150216.dmp
logfile=import.log

Where

SPEND_DBA: Common user who has database permission to export and import any schema. In this case, the user name/password are SPEND_DBA/SPEND_DBA.

SPEND102: SID, TNS, or Service ID that is required to connect to the Oracle server.

DUMP: Common directory location where the Oracle dump file is imported. The default location is /opt/dump.

Dumpfile: Name of the dump file that needs to be exported.

LogFile: If any errors occur during the dump, the error messages are logged in the LogFile.

After the dump file is successfully imported, you can view in which schema the file was imported as shown in the following image.

You can use the same log-in name and password to log in to the schema.