Import Oracle Dump (.dmp) File

You can use the Oracle IMP utility to import the content of a Oracle .dmp file.

If the dump file was created from one schema, but you want to import tables into another schema IMP allows you to change the schema/user name using FROMUSER and TOUSER options:

IMP system/password FILE=file.dmp FROMUSER=scott TOUSER=john

IMP utility unlike Data Pump does not have an option to change the tablespace during import.

But you can follow the following steps to get around this limitation and change the tablespace.

• Create tables

You can run IMP utility against the .dmp file and generate CREATE TABLE scripts using INDEXFILE option:

IMP system/password FILE=file.dmp FROMUSER=scott TOUSER=john INDEXFILE=script.sql

Then modify the generated script.sql file, remove comments and change the tablespace name to require value.

• Import

After you created the tables in the required tablespace, you can run IMP with IGNORE=y option to import data:

IMP system/password FILE=file.dmp FROMUSER=scott TOUSER=john IGNORE=y