This discussion is archived
7 Replies Latest reply: Oct 23, 2013 1:32 AM by AmitGargOCE RSS

Using EXCLUDE=STATISTICS option in export data pump (expdp)

AmitGargOCE Explorer
Currently Being Moderated

We have used EXCLUDE=STATISTICS option in export data pump (expdp). When importing (impdp) to new database, you have noticed some missing INDEXES in target. If we remove EXCLUDE=STATISTICS option, then we can match all indexes.

expdp system/<passwd> directory=EXP_DIR dumpfile=<dump>.dmp PARALLEL=8 SCHEMAS= <SCHEMAS , separated>  logfile=<logfile>.log EXCLUDE=STATISTICS

impdp system/<passwd> directory=IMP_DIR dumpfile==<dump>.dmp PARALLEL=8 SCHEMAS= <SCHEMAS , separated> logfile=<logfile>.log

Anyone noticed this problem in 11g database?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points