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
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
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment