Solved

Oracle 10g Data Pump Problem

Posted on 2006-06-09
4
2,402 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 19

Accepted Solution

by:
actonwang earned 250 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

Want Experts Exchange at your fingertips?

With Experts Exchange’s latest app release, you can now experience our most recent features, updates, and the same community interface while on-the-go. Download our latest app release at the Android or Apple stores today!

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Suggested Courses

617 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