Thursday 2 May 2013

FIX-ORA-39002: invalid operation ORA-39165: Schema IDIVE was not found.

 FIX-ORA-39002: invalid operation
ORA-39165: Schema IDIVE was not found.


impdp system DUMPFILE=xxx.sql LOGFILE=xxxx.log schemas=YYY remap_schema=XXX:YYY table_exists_action=REPLACE


When there is a new dump from production user needs only schema like ide 
use this command ide is source idive is target

impdp manjit/manjit directory=manjit_dp dumpfile=dp_31Dec121315.dmp logfile=dp_31Dec121315.log remap_schema=idi:idive

OR THE PERFECT1

     impdp directory=dpump file=dp_22Oct121315.dmp log=ms2.log schemas=msmd_ive remap_schema=msmd_ive:rms

SOLUTION: REMAP_SCHEMA=IDI_IVE:IDIIVE

No comments:

Post a Comment