Database Software

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!

IMPDP in oracle 11g

1010425May 22 2013 — edited May 22 2013

I want to import 'data_only' into 11 oracle schemas from exp file while remapping 4 schemas. I tried below command:
impdp system/bluelou dumpfile=exp_database.dmp logfile=import_database.log REMAP_SCHEMA=old_schema1:new_schema1,old_schema2:new_schema2,
old_schema3:new_schema3..................old_schema11:new_schema11 grants=y conent_data_only

And i realized that I dont have 'data_only' option in remap:schema. can some one advice how to handle this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on May 22 2013

#database-key-features, #export-import-sql-loader-external-tables

4 comments

4,174 views