Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle 10g Data Pump Problem

Posted on 2006-06-09
4
Medium Priority
?
2,464 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:modle
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
actonwang earned 750 total points
ID: 16875114
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
 

Author Comment

by:modle
ID: 16907547
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
 
LVL 19

Expert Comment

by:actonwang
ID: 16911548
not sure. but try to apply the patch and see..
0
 

Author Comment

by:modle
ID: 17216086

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question