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 -> problem export in oracle 10g

problem export in oracle 10g

From: Renato <renato.diogo_at_gmail.com>
Date: 27 Nov 2006 05:56:49 -0800
Message-ID: <1164635809.370489.194520@h54g2000cwb.googlegroups.com>


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.
==
Received on Mon Nov 27 2006 - 07:56:49 CST

Original text of this message

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