Author: skate
Time: 2007/12/28
When I run impdp
[Oracle @ New-host-2 ~] $ Impdp system/rnwoxn table_exists_action = replace directory = data_pump_dir dumpfile = movo_new.dmp schemas = movo_new remap_schema = movo_new: movo_new
...
...
...
ORA-39125: worker unexpected fatal error in KUPW $ worker. put_ddls while calling dbms_metadata.convert []
ORA-06502: PL/SQL: numeric or value error
LPX-00230: Invalid character 52 (U + 0034) found in a name or nmtoken
ORA-06512: At "SYS. dbms_sys_error", line 95
ORA-06512: At "SYS. KUPW $ worker", line 6235
----- PL/SQL call stack -----
Object line Object
Handle number name
0x26472998 14916 package body SYS. KUPW $ worker
0x26472998 6300 package body SYS. KUPW $ worker
0x26472998 12279 package body SYS. KUPW $ worker
0x26472998 3279 package body SYS. KUPW $ worker
0x26472998 6889 package body SYS. KUPW $ worker
0x26472998 1262 package body SYS. KUPW $ worker
0x29965178 2 anonymous Block
Job "system". "sys_import_schema_09" stopped due to fatal error at 11:47:32
It has been verified that it was originally an impdp bug of Oracle10g.
I saw a friend's article on the Internet.
Check this in Metalink:
Bookmarks to the end
Document ID: Note: 272874.1
Topic: Export DataPump: ORA-39125 fatal error in worker while calling dmsys. dbms_dm_model_exp.schema_callout
Type: Problem
Status: published
Text/X-HTML
Creation date: 17-may-2004
Last revised: 02-jul-2004
The information in this article applies:
Enterprise Manager for RDBMS-version: 10.1.0.0 to 10.2.0.0
Oracle Server-Enterprise Edition-version: 10.1.0.0 to 10.2.0.0
Oracle Server-Personal Edition-version: 10.1.0.0 to 10.2.0.0
Oracle Server-Standard Edition-version: 10.1.0.0 to 10.2.0.0
This problem can occur on any platform.
Errors
ORA-04063
ORA-06508
ORA-06512
ORA-31642
ORA-39125
What I use now is:
SQL> select * from V $ version
2;
Banner
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod
PL/SQL release 10.2.0.1.0-Production
Core 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0-Production
Nlsrtl version 10.2.0.1.0-Production
I am using Oracle 10.2.0.3.0 and Oracle 10.2.0.2.0.
10.2.0.1.0 bug,
Fixing bugs To be continued...
References:
Http://orchidllh.itpub.net/post/4020/24082