Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Datapump EXCLUDE parameter
Does anyone know how to use EXCLUDE at the table level for a full export?
Here is the partial parfile:
directory=dpump_exp_dir
dumpfile=Full.%U.dmp
full=y
logfile=Full.log
exclude=statistics
parallel=4
exclude=schema:"='TEST'"
exclude=table:"='TEST_TAB'"
But say there is a table called TEST_TAB in more than one schema, and I'd like to exclude the table from only one of the schemas.
Thanks!!
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 30 2007 - 12:38:20 CDT
![]() |
![]() |