Hi ..
I was trying to exclude a set of tables from my Full DB EXPDP backup job with the below script... But the set of tables which I intend to exclude are not getting excluded..
Can anyone help me with this... any help would be much appreciated..
Thanks in advance for your time and reply!!
This is the part of the shell script which does the expdp...
All of the variables are declared earlier in the shell script
${ORACLE_HOME}/bin/expdp \
directory=${EXP_PMP} \
FULL=Y \
dumpfile=${EXP_FILE}_%U \
COMPRESSION=ALL \
FILESIZE=92G \
logfile=${EXPDP_LOG} \
EXCLUDE=TABLE:\"IN \(SELECT TABLE_NAME FROM BKP_EXCLUDED_TABLES\)\" \
parallel=5 \
parfile=$BIN_DIR/expdp_full_${ORACLE_SID}.par
Here I have created a table SYS.BKP_EXCLUDED_TABLES where I have inserted the list of tables which I wish to exclude...
A sample o/p of the table...
SQL> select TABLE_NAME from bkp_excluded_tables;
TABLE_NAME
----------------------------------------
'ZZGVNGZVFDKRFEPNDUJZTDXYJBFKTP'
'ZZBTESDUFTEEZCBQBBEMZVWNXWVRZV'
..........