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!

Need help on doing full import but expluding SYSTEM tables like REPCAT$%

411198Jun 23 2009 — edited Jun 23 2009

Hi!

I am using impdp and want to do a full import of the source database but exclude tables (and dependent objects like indexes, etc.) owned by the SYSTEM user like REPCAT$%, AQ$%, etc. Have tried several things with no success. Need a working example if at all possible.

Thanks in advance!

Dave Venus

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 21 2009

Added on Jun 23 2009

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

7 comments

1,600 views