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!

how to do a full export and exclude user specific tables

746721Jan 19 2010 — edited Jan 19 2010
Hi all,

Is it possible to export all objects but one (or more) tables with expdp when doing a full export?

This is what I've to in mind: (parfile)

directory=expdp
dumpfile=full.dmp
logfile=full.elog
full=y
exclude=table:"IN('userA.table_A')"

This par-file does not encounter any error messages but it doesn't exclude table_A in schema userA either.
I guess that's because the the term userA is not interpreted as an owner.
It's not a big deal to filter out a table when doing a schema export.

I wonder whether it is at all possible do except a table from a full export. If so, I'd value your suggestions.

Regards,
Louis
This post has been answered by Dean Gagne-Oracle on Jan 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2010
Added on Jan 19 2010
1 comment
3,122 views