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
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