Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem export in oracle 10g
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