Issue: I was doing an import using datapump and encountered the below error.
Database version: 12.1.0.2.0
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 11252
----- PL/SQL Call Stack -----
object line object
handle number name
0xe6850a88 27109 package body SYS.KUPW$WORKER
0xe6850a88 11279 package body SYS.KUPW$WORKER
0xe6850a88 24279 package body SYS.KUPW$WORKER
0xe6850a88 20683 package body SYS.KUPW$WORKER
0xe6850a88 4545 package body SYS.KUPW$WORKER
0xe6850a88 12056 package body SYS.KUPW$WORKER
0xe6850a88 2081 package body SYS.KUPW$WORKER
0x3584ffed0 2 anonymous block
Solution:
We have a work around to this issue. Reimport the data with impdp and use an additional parameter EXCLUDE=STATISTICS.
I was able to import the data successfully and post the import I have gathered the stats using the DBMS_STATS package.
