Database Backup and Recovery (MOSC)

MOSC Banner

Datapump import errors

Hello all,

I am doing a Datapump export using the following parameters -

$ORACLE_HOME/bin/expdp AAAAAA/BBBB@CCCCCC SCHEMAS=DDDDDD DIRECTORY=DATA_PUMP_DIR_DDDDDD dumpfile=DDDDDD-$DATE.dmp logfile=DDDDDD-$DATE.log flashback_time=systimestamp.

The export job completes successfully.

Using the dump file created in the abovementioned job, I now run a Datapump import job - on the same system/DB/schema using the following parameters -

$ORACLE_HOME/bin/impdp \"/ as sysdba\" DIRECTORY=DATA_PUMP_DIR_DDDDDD dumpfile=DDDDDD-$DATE.dmp SCHEMAS=DDDDDD logfile=impdp_DDDDDD.log TABLE_EXISTS_ACTION=REPLACE

The import job "completes" however, with errors -

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