7 Replies Latest reply: Oct 23, 2013 3:32 AM by AmitGargOCE RSS

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

    AmitGargOCE

      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?