Tuesday, February 27, 2018

EXPDP with excluding STATISTICS,INDEX

expdp t24backup/**** DIRECTORY=dir_n1 dumpfile=$vdate%U.dmp logfile=$vdate.log schemas=testt24 parallel=15 EXCLUDE=STATISTICS,INDEX:\"IN \(\'IX_FBNK_STMT_ENTRY_C1\'\,\'IX_FBNK_STMT_ENTRY_C25\'\,\'IX_FBNK_STMT_ENTRY_C23\'\,\'IX_FBNK_CATEG_ENTRY\'\)\" CLUSTER=N metrics=y

expdp t24backup/*** DIRECTORY=dump_dir dumpfile=$vdate%U.dmp logfile=$vdate.log schemas=testt24 parallel=15 EXCLUDE=STATISTICS,INDEX:\"IN \(\'IX_FBNK_STMT_ENTRY_C1\'\,\'IX_FBNK_STMT_ENTRY_C25\'\,\'IX_FBNK_STMT_ENTRY_C23\'\,\'IX_FBNK_CATEG_ENTRY\'\)\" CLUSTER=N metrics=y

No comments:

Post a Comment