Import Job failed with the unexpected fatal error and followed with the “ORA-30926” and the trace information as below.
processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER ORA-39126: Worker unexpected fatal error in KUPW$WORKER.STATS_LOAD [MARKER] MARKER ORA-30926: unable to get a stable set of rows in the source tables ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.KUPW$WORKER", line 11265 ----- PL/SQL Call Stack ----- object line object ----- PL/SQL Call Stack ----- object line object handle number name 0x179cd81178 27116 package body SYS.KUPW$WORKER 0x179cd81178 11286 package body SYS.KUPW$WORKER 0x179cd81178 24286 package body SYS.KUPW$WORKER 0x179cd81178 24415 package body SYS.KUPW$WORKER 0x179cd81178 20692 package body SYS.KUPW$WORKER 0x179cd81178 10206 package body SYS.KUPW$WORKER 0x179cd81178 13381 package body SYS.KUPW$WORKER 0x179cd81178 3173 package body SYS.KUPW$WORKER 0x179cd81178 12035 package body SYS.KUPW$WORKER 0x179cd81178 2081 package body SYS.KUPW$WORKER 0x177b588fa8 2 anonymous block In STATS_UNLOAD DBMS_STATS.EXPORT_STATS_FOR_DP DBMS_STATS.EXPORT_STATS_FOR_DP In STATS_LOAD with process_order 131 Fixing up the name in the impdp stat table ORA-39126: Worker unexpected fatal error in KUPW$WORKER.STATS_LOAD [MARKER] ORA-30926: unable to get a stable set of rows in the source tables ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPW$WORKER", line 11259 ----- PL/SQL Call Stack ----- object line object handle number name 0x179cd81178 27116 package body SYS.KUPW$WORKER 0x179cd81178 11286 package body SYS.KUPW$WORKER 0x179cd81178 24286 package body SYS.KUPW$WORKER 0x179cd81178 24415 package body SYS.KUPW$WORKER 0x179cd81178 10105 package body SYS.KUPW$WORKER 0x179cd81178 13381 package body SYS.KUPW$WORKER 0x179cd81178 3173 package body SYS.KUPW$WORKER 0x179cd81178 12035 package body SYS.KUPW$WORKER 0x179cd81178 2081 package body SYS.KUPW$WORKER 0x177b588fa8 2 anonymous block In STATS_UNLOAD DBMS_STATS.EXPORT_STATS_FOR_DP DBMS_STATS.EXPORT_STATS_FOR_DP In STATS_LOAD with process_order 131 Fixing up the name in the impdp stat table Job "SYSTEM"."ODSPRD1_NL" stopped due to fatal error at Mon Oct 11 13:29:52 2021 elapsed 0 00:02:48
There is nothing new in the import and later in MOS found this issue as a bug
Bug 19731829 – Issues With Pack and Unpack of SQL Plan Directives – Can Cause ORA-39126 / ORA-00001 or ORA-39126 / ORA-30926 on Data Pump Import (Doc ID 19731829.8)
Hitting ORA-30926 During DataPump Import Job When Processing The Statistics (Doc ID 2162936.1)
As per the MOS notes, performed the below steps to complete successfully.
SQL> exec dbms_stats.gather_dictionary_stats; PL/SQL procedure successfully completed. SQL> exec dbms_stats.lock_table_stats (null,'X$KCCLH'); PL/SQL procedure successfully completed. SQL> exec dbms_stats.gather_fixed_objects_stats; PL/SQL procedure successfully completed. SQL>
After performing the above steps, the import was successful
[oracle@ORA-X1~]$ tail -100f nohup_odsprd1_impnl_tbl.log nohup: ignoring input Import: Release 12.1.0.2.0 - Production on Mon Oct 11 13:43:40 2021 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Legacy Mode Active due to the following parameters: Legacy Mode Parameter: "grants=TRUE" Location: Parameter File, ignored. Starting "SYSTEM"."ODSPRD1_NL_TBL": system/******** parfile=odsprd1_impdp_pdc.par Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 747 MB Processing object type TABLE_EXPORT/TABLE/TABLE . . imported "NM"."PRODUCT_DIMENSION" 1625225 rows Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/BITMAP_INDEX/INDEX Job "SYSTEM"."ODSPRD1_NL_TBL" successfully completed at Mon Oct 11 13:44:47 2021 elapsed 0 00:01:06
