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!

exp multiple schemas and import with full=y

PDPMay 30 2014 — edited May 30 2014

Hi all,

oracle 11g r2

rhel 5

I have taken an oracle datapump schema backup using parameter schemas=schema1, schema2, schema3

Using the same dump file im importing it to another database in another server by using following method

impdp username/password directory=data_pump_dir dumpfile=file.dmp logfile=file.log schemas=schema1,schema2,schema3 table_exists_action=replace

impdp username/password directory=data_pump_dir dumpfile=file.dmp logfile=file.log full=y table_exists_action=replace

Is there any difference in importing when using "schemas" and "full" parameter in impdp command?

I feel like both command will do all full schema import..

any comments please??

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2014

Added on May 30 2014

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

2 comments

3,512 views