EXPDP not doing what I need it to do
Windows 2008 Server Oracle 11gR2
EXPDP Not working to exclude tables :
I want to exclude 2 tables from an export using datapump. Here is my syntax :
expdp system/passwd DIRECTORY=DATA_PUMP_DIR FULL=Y DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log EXCLUDE=TABLE:\"IN ('schema.tbl1', 'schema.tbl2')\"
The export runs fine but the data in the two tables I want excluded is exported also.
Ideas ??
EXPDP Not working to exclude tables :
I want to exclude 2 tables from an export using datapump. Here is my syntax :
expdp system/passwd DIRECTORY=DATA_PUMP_DIR FULL=Y DUMPFILE=exp_tab.dmp LOGFILE=exp_tab.log EXCLUDE=TABLE:\"IN ('schema.tbl1', 'schema.tbl2')\"
The export runs fine but the data in the two tables I want excluded is exported also.
Ideas ??
0