Print Friendly, PDF & Email

 
ISSUE

During a datapump import you got the error like the following 

impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log

...

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1838
ORA-06512: at line 2
Processing object type SCHEMA_EXPORT/JOB
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA

 
No one is connected to a database during an import but the user SYSTEM who is performing the import itself. You have sufficient SGA/PGA size in your database.

 
 
SOLUTION

 
To eliminate the error with the worker, exclude statistics during an import

impdp system/manager1 schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log EXCLUDE=STATISTICS

 
NOTE : With EXCLUDE=STATISTICS parameter only tables are not being analyzed during an import. Indexes will be analyzed anyway. Review Doc ID 793585.1 for details.

When import is completed, gather schema statistics by executing the DBMS_STATS.GATHER_SCHEMA_STATS procedure

exec DBMS_STATS.GATHER_SCHEMA_STATS('XXCDB');

 
 
REFERENCE
 
EXCLUDE=STATISTICS Or EXCLUDE=INDEX_STATISTICS During Datapump Import Still Analyzes The Indexes (Doc ID 793585.1)

 
 

Version  : 16:45 22.07.2020
Database : 11.2.0.4