Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

AmitGargOCEOct 11 2013 — edited Oct 23 2013

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 20 2013

Added on Oct 11 2013

#11g, #database, #database-key-features, #export-import-sql-loader-external-tables, #parameter

7 comments

59,903 views