Oracle 10g Data Pump Problem

I am running Oracle 10g R1 on Solaris 10 x86.  I am trying to use the Data Pump to import 1 Gig of data.

I keep getting the following error:

C:\Test1>impdp MYNET/********@DB_000.00.00.00 directory=TEST_DIR dumpfile=K0.DMP logfile=ImpK0.log
 
Import: Release 10.1.0.2.0 - Production on Friday, 09 June, 2006 15:37
 
Copyright (c) 2003, Oracle.  All rights reserved.
 
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Master table "MYNET"."SYS_IMPORT_FULL_14" successfully loaded/unloaded
Starting "MYNET"."SYS_IMPORT_FULL_14":  MYNET/********@DB_000.00.00.00 d
irectory=TEST_DIR dumpfile=K0.DMP logfile=ImpK0.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
. . imported "MYNET"."K0P_G"                    90.75 MB  193385 rows
. . imported "MYNET"."K7P_G"                    81.35 MB  167372 rows
. . imported "MYNET"."K0P_D"                79.99 MB  313669 rows
. . imported "MYNET"."K0P_X"                    68.60 MB  164903 rows
. . imported "MYNET"."K7P_X"                    67.20 MB  161043 rows
. . imported "MYNET"."K0P_C"                66.43 MB  118943 rows
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: [kcrf_pvt_strand_bind1], [0], [1], [4
], [14], [2], [], []
ORA-06512: at "SYS.KUPF$FILE", line 4448
ORA-06512: at line 1
ORA-06512: at "SYS.KUPW$WORKER", line 1276
ORA-06512: at line 2
 
Job "MYNET"."SYS_IMPORT_FULL_14" stopped due to fatal error at 15:35
modleAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
actonwangConnect With a Mentor Commented:
this is a bug in 10.1.0.3.0
see:
https://metalink.oracle.com/metalink/plsql/f?p=130:14:9438124723431826567::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,341456.1,1,1,1,helvetica

This bug is fixed in 10.1.0.4.
Please download and apply the 10.1.0.4 patchset where the issue is resolved.


Acton
0
 
modleAuthor Commented:
OK - we will give that a shot.

One interesting note - we had to reboot the system over the weekend and now the data pump is working fine.  Is it possible we were running out of memory?
0
 
actonwangCommented:
not sure. but try to apply the patch and see..
0
 
modleAuthor Commented:

Oracle 10 R2 is now available for Solaris x86.  We upgraded to R2.  We needed to install a new instance - it appears its due to 32 bit vs 64 bit incompatibility.

The data pump now gives us no trouble.
0
All Courses

From novice to tech pro — start learning today.