Database - RAC/Scalability (MOSC)

MOSC Banner

Data Pump Export Full with EXCLUDE table parameter

edited Dec 1, 2015 10:05AM in Database - RAC/Scalability (MOSC) 12 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center