Solved

Oracle 10g Data Pump Problem

Posted on 2006-06-09
4
2,383 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

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

Suggested Solutions

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…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

740 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