Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problem export in oracle 10g
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-01000: maximum open cursors exceeded ORA-06512: at line 2
==================================
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