Data Pump

How to Resolve impdp STATISTICS Stuck

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

Leave a Reply

Your email address will not be published. Required fields are marked *