Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Importing multiple schemas; Is REMAP_SCHEMA parameter actually needed?

james_pApr 9 2010 — edited Apr 9 2010

DB Version:11g

Using the below par file, i took the dump file of 3 schemas

DIRECTORY=dpump_dir1
dumpfile=IMPORTANT_SCHEMAS.dmp
SCHEMAS=schema1,schema2,schema3
LOGFILE= IMPORTANT_SCHEMAS.log
EXCLUDE=GRANT

Now i want to import the above 3 schemas to a new database.
For impdp, should i use

REMAP_SCHEMA=schema1:schema1,schema2:schema2,schema3:schema3

or just

schemas=schema1,schema2,schema3

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2010

Added on Apr 9 2010

#general-database-discussions

5 comments

34,578 views