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!

expdp/impdp a partitioned DB

h.mehdiDec 5 2010 — edited Dec 7 2010

Hi,

I'm importing a full DB with partitioned tables but have errors like this:

ORA-31693: Table data object "SOMETHING"."SS_TRANSACTION_HIST":"SS_TRANSACTION_HIST_0907" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-14400: inserted partition key does not map to any partition

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2011

Added on Dec 5 2010

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

4 comments

1,899 views