Import using impdp alongwith Internal error [message #395407] |
Wed, 01 April 2009 06:00 |
vinniora
Messages: 56 Registered: October 2008 Location: Mumbai
|
Member |
|
|
Hi all, I am daily importing the tables from database using impdp by using impdp and the query for this is
$ORACLE_HOME/bin/impdp system/admin@Dwbase schemas=abc,xyz directory=table_export dumpfile=abcd.dmp TABLE_EXISTS_ACTION=truncate remap_tablespace=abc_data:users remap_tablespace=abc_idx:users exclude=TABLE:\"IN\(\'P3_PF_ORDER_SMS_L2\',\'FP_LOGDATA_TEST\',\'FP_LOGDATA\',\'P_IDOC_TRACE\'\)\" logfile=logbkp.log
past 6-7 days it was working fine ,still to date import is working fine but now it is alongwith internal error and it is occuring daily at 9 am(india timing ) the error which i shown in log file is as
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [qerxtAgentOpen_911], [5], [4], [], [ ], [], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1345
ORA-06512: at line 2
Job "SYSTEM"."SYS_IMPORT_SCHEMA_16" stopped due to fatal error at 08:58:46
ORA-39014: One or more workers have prematurely exited.
So please help me in this why it is occuring.Thnx in advance
|
|
|
|