Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem export in oracle 10g

Re: problem export in oracle 10g

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 27 Nov 2006 07:44:11 -0800
Message-ID: <1164642251.347321.97450@n67g2000cwd.googlegroups.com>


Renato wrote:
> Hi
>
> I have a RedHat 4 ES with oracle 10g
>
> I have a big table and I happend errors when try export the base
>
> I used the expdp.
>
> Obs.: other small base works fine.
>
> Above the piece of gerated logs.
>
>
> ==
> ;;;
> Export: Release 10.2.0.1.0 - 64bit Production on Monday, 27 November,
> 2006 1:01:02
>
> Copyright (c) 2003, 2005, Oracle. All rights reserved.
> ;;;
> Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
> - 64bit Production
> With the Partitioning, OLAP and Data Mining options
> Starting "E-ORDER"."SYS_EXPORT_SCHEMA_05": e-order/********@globalph
> schemas=E-ORDER directory=dir_backup dumpfile=E-ORDER.2006112701.dmp
> logfile=E-ORDER.2006112701.log
>
> ==================================
>
> ORA-31693: Table data object "E-ORDER"."ITEM_NOTA" failed to
> load/unload and is being skipped due to error:
> ORA-00001: unique constraint (E-ORDER.SYS_C0015662) violated
> ORA-06512: at "SYS.KUPF$FILE", line 2580
> ORA-06512: at line 1
>
> ==================================
>
> ORA-31693: Table data object "E-ORDER"."ITEM_NOTA" failed to
> load/unload and is being skipped due to error:
> ORA-02354: error in exporting/importing data
> ORA-00604: error occurred at recursive SQL level 3
> ORA-01000: maximum open cursors exceeded
> ORA-06512: at "SYS.DBMS_METADATA", line 1546
> ORA-06512: at "SYS.DBMS_METADATA", line 1583
> ORA-06512: at "SYS.DBMS_METADATA", line 1891
> ORA-06512: at "SYS.DBMS_METADATA", line 3806
> ORA-06512: at "SYS.DBMS_METADATA", line 4502
> ORA-06512: at line 1^@
>
>
> ==================================
>
> 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-39097: Data Pump job encountered unexpected error -1000
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
> ORA-06512: at "SYS.KUPC$QUE_INT", line 1274
> ORA-01000: maximum open cursors exceeded
> ORA-06512: at "SYS.KUPC$QUE_INT", line 1709
> ORA-06512: at line 1
> ORA-06512: at "SYS.KUPC$QUEUE_INT", line 277
> ORA-06512: at "SYS.KUPW$WORKER", line 1314
> ORA-01000: maximum open cursors exceeded
> ORA-06512: at line 2
> Job "E-ORDER"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at
> 01:06:25
> ORA-39014: One or more workers have prematurely exited.
> ==

More information would be helpful.

Have you every successfully exported the database using expdp?

What is the result of this query:
SELECT
  NAME,
  VALUE
FROM
  V$PARAMETER
WHERE
  NAME='open_cursors';

What are the results of this query?
SELECT
  OWNER,
  CONSTRAINT_NAME,
  CONSTRAINT_TYPE,
  TABLE_NAME,
  R_OWNER,
  R_CONSTRAINT_NAME,
  VALIDATED,
  LAST_CHANGE
FROM
  DBA_CONSTRAINTS
WHERE
  STATUS<>'ENABLED'
ORDER BY
  OWNER,
  TABLE_NAME,
  CONSTRAINT_NAME; There is a similar error reported on Metalink, but no solution provided.

Patch 4634712 for 10.2.0.1 corrects "EXPDP ERRORS ORA-39125 ORA-22814 ORA-06512" Have you considered applying the 10.2.0.2 and possibly then applying patch 9 for 10.2.0.2? 10.2.0.2 corrects a couple bugs in expdp.

With the additional details, someone else on this group may be able to provide additional assistance.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Nov 27 2006 - 09:44:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US