Database Utilities (MOSC)

MOSC Banner

IMPDP fails with ORA-31693, ORA-02354, ORA-01403

edited May 28, 2014 12:00PM in Database Utilities (MOSC) 1 commentAnswered

I have a customer trying to import data into a 10.2.0.4 instance. The source system was  (probably) 10.2.0.4.12 32bit, the target is 10.2.0.4.0 64bit.

Export command was expdp dumpfile=DATA_PUMP_DIR_3:<schema>_01.dmp,DATA_PUMP_DIR:<schema>_02.dmp,DATA_PUMP_DIR:<schema>_03.dmp logfile=<schema>_`date +%Y%m%d_%H%M%S`.log filesize=25G  schemas=<schema>

Most of the data in the dump files is BLOB data.

I asked the customer to drop the schema, create a SQL file from the dmp file and run that. This was successful. They ran another import with CONTENT=DATA_ONLY and received errors KUP-11007, ORA-01403

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center