Data Pump Export Full with EXCLUDE table parameter
Hello,
I have a 1.2TB database RAC 10.2.0.5 and I have to export all data with data pump every night.
There is a big table, about 115GB, in a schema that I can't export because ORA-01555 error (snapshot too old). I tried to increment undo_retention parameter but it was the same.
I want to exclude it from the export.
expdp system/******* DUMPFILE=$BACKUPDMP LOGFILE=$BACKUPDMPLOG PARFILE=$EXECDIR/export_full_expdp.par
export_full_expdp.par:
FULL=Y
CONTENT=ALL
PARALLEL=4
JOB_NAME=EXPFULL00
EXCLUDE=TABLE:"IN('LAB.LISRISREF')"
LAB.LISRISREF is the big table but data pump export continue to try to export it and stops with a ORA-01555.