Home » RDBMS Server » Server Utilities » Import using impdp alongwith Internal error (Oracle Database 10g,Linux 2.6.18-8.el5)
Import using impdp alongwith Internal error [message #395407] Wed, 01 April 2009 06:00 Go to next message
Messages: 56
Registered: October 2008
Location: Mumbai
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

Re: Import using impdp alongwith Internal error [message #395418 is a reply to message #395407] Wed, 01 April 2009 06:21 Go to previous message
Michel Cadot
Messages: 64501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Previous Topic: Converting Column headings into values
Next Topic: Format Udump Trace Files
Goto Forum:

Current Time: Wed Mar 01 12:05:41 CST 2017

Total time taken to generate the page: 0.19846 seconds