Skip to Main Content

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!

Datapump Export - multiple EXCLUDE patterns for TABLE

user599560Apr 15 2009 — edited Apr 16 2009
I'm performing an export and I have two classes of tables (as in LIKE filters) that I wish to exclude. I've tried using multiple LIKE statements:

EXCLUDE=TABLE:"LIKE 'FILTER1%'"
EXCLUDE=TABLE:"LIKE 'FILTER2%'"

However this way it appears the second EXCLUDE overwrites the first and only tables matching FILTER2% are excluded.

Doing it like this has the same behavior and only tables matching FILTER2 are excluded

EXCLUDE=TABLE:"LIKE 'FILTER1%'",TABLE:"LIKE 'FILTER2%'"

The following are not syntactically correct but seemed worth trying

EXCLUDE=TABLE:"LIKE 'FILTER1%' OR 'FILTER2%'"

EXCLUDE=TABLE:"LIKE 'FILTER1%' OR LIKE 'FILTER2%'"

Is there any way to accomplish what I'm trying to do here? This is 10.2.0.2.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2009
Added on Apr 15 2009
3 comments
5,081 views