Importing Stuck at STATISTICS
When I imported data via a network link, I found it stuck at STATISTICS.
...
Import: Release 12.1.0.2.0 - Production on Wed Sep 26 20:47:29 2018
...
Starting "SYSTEM"."SYS_IMPORT_TABLE_01": system/******** tables=ERPAPP.BANKS content=all table_exists_action=replace network_link=erp_db_link logfile=imp_table_erpapp.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10 MB
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/TABLE
. . imported "ERPAPP"."BANKS" 55523 rows
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
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-00001: unique constraint (SYS.PK_COL_GROUP_USAGE$) violated
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 11265
...
The data pump job stuck at STATISTICS. More precisely, STATISTICS/MARKER
Workaround
You can make a workaround for this stuck: just exclude the object path in your data pump job.
EXCLUDE=STATISTICS
For more operable parameters of impdp, please refer to: impdp Parameter for All Releases of Oracle Database.