how to do a full export and exclude user specific tables
746721Jan 19 2010 — edited Jan 19 2010Hi 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