Question: I want to exclude certain tables on the job during the
expdp processclude in the expdp.
Answer:
The
expdp
exclude parameter is used inside a parameter file
(parfile) to exclude a single table, a list of tables or a
list using the LIKE clause, or entire schemas:
expdp scott/tiger parfile=mypar.par
root> cat mypar.par
directory=data
logfile=t1.log
dumpfile=t1.dmp
full=yes
exclude=table:"IN('CUSTOMER','ORDOR)"
exclude=schema: "IN ('WMSYS', 'OUTLN')"
If the expdp exclude parameter is used directly
from the command line (and not in a parameter file
(parfile)), the special characters (quote marks) in the
exclude
clause may need to be escaped with backslash (\)
character. Because of this, it is recommended that you always use a parameter file (parfile).
Windows:
c:> expdp
scott/tiger exclude=TABLE:"IN (\'CUSTOMER\', \'ORDOR\')"
UNIX/Linux:
root> expdp
scott/tiger exclude=TABLE:\"IN (\'CUSTOMER\', \'ORDOR\')\"
Refernce: MOSC note 1535814.1 "How To Exclude Data In One Table Owned By A Specified User During DataPump Export?".
