My Oracle Support Banner

Exporting Partitioned Table With Subpartitions Using expdp Fails With ORA-31693, ORA-02354, ORA-00604, ORA-01426 (Doc ID 305096.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.1.0.4 [Release 10.1]
Information in this document applies to any platform.
***Checked for relevance on 08-Apr-2013***

Symptoms

When exporting a partitioned table with sub-partitions using Export Datapump (expdp), it fails with ORA-31693, ORA-02354, ORA-00604, ORA-01426.

Export Datapump log file shows:

Processing object type TABLE_EXPORT/TABLE/TBL_TABLE_DATA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10.75 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/TBL_OWNER_OBJGRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/TBL_FBM_INDEX_INDEX/INDEX
. . exported "SCOTT"."SALES":"UDRDW01022005"  1.011 GB 6603230 rows
. . exported "SCOTT"."SALES":"UDRDW02022005"  1.033 GB 6744160 rows
. . exported "SCOTT"."SALES":"UDRDW03022005"  912.0 MB 5816008 rows
. . exported "SCOTT"."SALES_BKDT":"UDRDWB01022005"  61.17 KB     212 rows
. . exported "SCOTT"."SALES_BKDT":"UDRDWB02022005"  78.02 KB     304 rows
. . exported "SCOTT"."SALES_BKDT":"UDRDWB03022005"  99.97 KB     431 rows
ORA-31693: Table data object "SCOTT"."SALE_CALL_CHARGE_FACT":"SCPDW01022005"."SCPDW01022005_SCPDBHRBAND10" 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-01426: numeric overflow
ORA-31693: Table data object "SCOTT"."SALE_CALL_CHARGE_FACT":"SCPDW01022005"."SCPDW01022005_SCPDBHRBAND11" 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-01426: numeric overflow
ORA-31693: Table data object "SCOTT"."SALE_CALL_CHARGE_FACT":"SCPDW01022005"."SCPDW01022005_SCPDBHRBAND12" 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-01426: numeric overflow

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.