APPLIES TO:
Oracle Database - Standard Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
SYMPTOMS
Import via network link the following error occurs.
ERROR
-----------------------
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00230: invalid character 60 (U+003C) found in a Name or Nmtoken
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
0x106f51dc30 21979 package body SYS.KUPW$WORKER
0x106f51dc30 9742 package body SYS.KUPW$WORKER
0x106f51dc30 17950 package body SYS.KUPW$WORKER
0x106f51dc30 8599 package body SYS.KUPW$WORKER
0x106f51dc30 11712 package body SYS.KUPW$WORKER
0x106f51dc30 2808 package body SYS.KUPW$WORKER
0x106f51dc30 10422 package body SYS.KUPW$WORKER
0x106f51dc30 1824 package body SYS.KUPW$WORKER
CAUSE
The issue was investigated in below BUG , but this was closed as required information was not available .
BUG 19712212 - IMPORTING STATISTICS WITH SOME EMOTICONS CHARACTER FAILED which was suspended
due to lack of extra information from the customer side and seems to match with the issue encountered.
Issue is always while import is running at stats phase .
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
SOLUTION
Action Plan
============
1. Re-run the impdp using the exclude parameter to exclude the statistics:
exclude=statistics
2. Collect the statistics after importing the data.
To gather the statistics you should run:
SQL> connect / as sysdba
SQL> exec dbms_stats.gather_dictionary_stats;
SQL> exec dbms_stats.gather_fixed_objects_stats;
If you want to gather the database stats / schema stats explicitly you may use below examples .
gathered for the database, schema, table or partition.
EXEC DBMS_STATS.gather_database_stats;
EXEC DBMS_STATS.gather_database_stats(estimate_percent => 15);
EXEC DBMS_STATS.gather_database_stats(estimate_percent => 15, cascade => TRUE);
EXEC DBMS_STATS.gather_schema_stats('SCOTT');
EXEC DBMS_STATS.gather_schema_stats('SCOTT', estimate_percent => 15);
EXEC DBMS_STATS.gather_schema_stats('SCOTT', estimate_percent => 15, cascade => TRUE);
REFERENCES
BUG:19712212 - IMPORTING STATISTICS WITH SOME EMOTICONS CHARACTER FAILED
NOTE:1392981.1 - Failure In 11.2.0.2, Success In 11.2.0.1 DBMS_DATAPUMP.METADATA_FILTER Exclude STATISTICS
