Impdp ORA-39126: Worker unexpected fatal error in KUPW $ WORKER. PUT_DDLS [TABLE_STATISTICS] solution, impdpkupw

Impdp ORA-39126: Worker unexpected fatal error in KUPW $ WORKER. PUT_DDLS [TABLE_STATISTICS] solution, impdpkupw

When using impdp to import data today, the following error message is returned, causing import failure.

ORA-06502: PL/SQL: numeric or value errorLPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95ORA-06512: at "SYS.KUPW$WORKER", line 9715----- PL/SQL Call Stack -----  object      line  object  handle    number  name0x1cc867b18     21979  package body SYS.KUPW$WORKER0x1cc867b18      9742  package body SYS.KUPW$WORKER0x1cc867b18     17950  package body SYS.KUPW$WORKER0x1cc867b18      4058  package body SYS.KUPW$WORKER0x1cc867b18     10450  package body SYS.KUPW$WORKER0x1cc867b18      1824  package body SYS.KUPW$WORKER0x1cc5a1bd0         2  anonymous blockORA-39097: Data Pump job encountered unexpected error -1427ORA-39065: unexpected master process exception in DISPATCHORA-01427: single-row subquery returns more than one rowJob "CLOUDPIG"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at Tue Mar 20 20:26:38 2018 elapsed 0 00:24:11

View MOS: Document ID 878626.1

The above two solutions are provided: 1. Patch 2. filter out the statistical value during impdp: EXCLUDE = STATISTICS

Therefore, the second method is used to add EXCLUDE = STATISTICS after impdp.

The import is successful. Remember to manually collect statistics when the import is complete.

execute dbms_stats.gather_schema_stats(ownname=>'xxxx')