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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms