Solved

Oracle 10g Data Pump Problem

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
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…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

820 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