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 all schema tables but exclude just a few.

Blues BreakerAug 9 2017 — edited Aug 17 2017

So I'm using 12c and I wanted to export with data pump all the schema tables ONLY and

EXCLUDE about a dozen. There are hundreds of tables and the few I want to exclude are very larger but I

cannot seem to get anything working.

expd user/pw tables=< there are hundreds of tables > exclude=< there just a dozen or so >

No problem with a short list of exclusion but I need to list hundreds of tables.

Shouldn't I be able to include all schema tables (like schema.* ) and just exclude what I don't want ?

Any ideas gratefully received,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 14 2017

Added on Aug 9 2017

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

16 comments

13,895 views