CODEWITHSUNDEEP
oracle-database
Lin Ma
Lin Ma

Reputation: 10149

username and password for importing Oracle .dmp file

Need to import an Oracle .dmp file, and wondering if there is a way to skip original username and password for the source Oracle database when we export the .dmp file? I have sys/system permission on the destination Oracle database.

thanks in advance, Lin

Upvotes: 0

Views: 5018

Answers (1)

Rene
Rene

Reputation: 10551

Using the impdp utility you can import using the system user. Specify remap_schema and remap_tablespace to import your tables into a different schema and tablespace.

impdp system/password@database dumpfile=dump.dmp directory=directory remap_schema=from:to remap_tablespace=from:to

Oracle documentation: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm

Upvotes: 1

Related Questions