Monday, February 27, 2012

Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com


Problem: Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

A full export fails with the following errors:

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA]
ORA-22813: operand value exceeds system limits
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6234
----- PL/SQL Call Stack -----
object line object
handle number name
3cc96edb8 14916 package body SYS.KUPW$WORKER
3cc96edb8 6293 package body SYS.KUPW$WORKER
3cc96edb8 2339 package body SYS.KUPW$WORKER
3cc96edb8 6854 package body SYS.KUPW$WORKER
3cc96edb8 1259 package body SYS.KUPW$WORKER
4e9a30880 2 anonymous block
Job "BKPADM"."SYS_EXPORT_FULL_04" stopped due to fatal error at 15:13:13

Symptoms:

expdp bkp/passwd dumpfile=dp_adp:expdp_adp-`date +%d%m%Y'`.dmp logfile=dp_adp:expdp_adp-`date +%d%m%Y'`.log full=y

Log files:



Solution:

This problem is caused by unpublished Bug 6991626 "EXPORT DATAPUMP FAILS WITH ORA-39126 AND ORA-22813":
Datapump export fails to write large volume data and gives error message "ORA-22813: operand value exceeds system limits".

There is no patch available on top of 10.2.0.3. To solve the issue:

1. Install the latest patchset 10.2.0.4 and then the patch.6991626 available on top of 10.2.0.4 for your platform.
Install the latest patchset 10.2.0.4 and then the patch.6991626 available on top of 10.2.0.4 for your platform.

References:

Note:781638.1 - Datapump Export Fails With ORA-39125 And ORA-22813 Operand Value Exceeds System Limits

Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: