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!

data pump import to a different schema name, and specific tables?

W JamieMar 3 2016 — edited Mar 5 2016

I am trying to load to a target database where the schema name is different than that of in the data pump dump file from a source, and I only want to load a few specific tables.

is there a way to do this with data pump import? I've tried a few different ways but it's not working..

for example, I've used the following in a par file, then I will run as "impdp B parfile=file"

DUMPFILE=xxx

LOGFILE=xxx

DIRECTORY=dpump

REMAP_SCHEMA=A:B

TABLES='"C"','"D"'.......

any ideas?

This post has been answered by Dean Gagne-Oracle on Mar 4 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2016

Added on Mar 3 2016

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

9 comments

13,367 views