Datapump import fails with ORA-39125 and ORA-01403 no data found
570642Jan 2 2009 — edited Oct 26 2009Happy new year eveyone,
I used Datapump to fully export a database (10.2.0.4). And then iimport the dumpfile into a new same version database.
impdp system/*** full=Y directory=TEST_PUMP_DIR dumpfile=UD_dp.dmp logfile=UD_dp_import.log table_exists_action=APPEND reuse_datafiles=Y
But, I got the following error, and import failed.
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS while calling DBMS_METADATA.SET_TRANSFORM_PARAM []
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6307
----- PL/SQL Call Stack -----
object line object
handle number name
357D3F5C 15032 package body SYS.KUPW$WORKER
357D3F5C 6372 package body SYS.KUPW$WORKER
357D3F5C 9876 package body SYS.KUPW$WORKER
357D3F5C 11909 package body SYS.KUPW$WORKER
357D3F5C 3346 package body SYS.KUPW$WORKER
357D3F5C 6972 package body SYS.KUPW$WORKER
357D3F5C 1314 package body SYS.KUPW$WORKER
357C8478 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_FULL_01" stopped due to fatal error at 17:43:11
Googled the internet and searched the forum and metalink, but couldn't find a solution to troubleshoot this eror. If you have any ideas or suggestions, pls kindly shed the light.
Thanks!