impdp ORA-39029 [message #553024] |
Tue, 01 May 2012 01:26 |
|
lerry
Messages: 16 Registered: December 2011
|
Junior Member |
|
|
impdp system/manager1 directory=dmpdir parfile=impdp_smp.txt
$cat impdp_smp.txt
dumpfile=full_0501_1.dmp,full_0501_2.dmp,full_0501_3.dmp,full_0501_4.dmp
schemas=smp
exclude=table:"in ('SFCS_SN_SITE_STATISTICS','KP_KEYPART_RUNCARD','CELL_SORT_INFO_BY_CUSTOMER',
'WIP_RUNCARD','KP_KEYPART_FLEX','SFCS_SN_SITE_STATISTICS _MV') "
remap_tablespace=USERS:APP_TB,SYSTEM:APP_TB
logfile=impdp_smp.log
parallel=4
impdp error:
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 12:26:24
ORA-39014: One or more workers have prematurely exited.
please help me How to solve this problem
thank you
[Updated on: Tue, 01 May 2012 01:38] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
Re: impdp ORA-39029 [message #553061 is a reply to message #553050] |
Tue, 01 May 2012 08:27 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Anyway, either some one kills dw01 either there is a bug.
Retry your import (maybe with less parallelism), if it does not work open a SR to Oracle.
Regards
Michel
|
|
|