How to find the cause of expdp failure of the schema tables enabled with data redaction policies (Doc ID 2578452.1)

Last updated on JUNE 14, 2021

Applies to:

Symptoms

 Exporting a schema(user1) table(table01) fails. It is unclear as to what is the cause for the failure of the expdp command

-bash-4.1$
-bash-4.1$ expdp user1/#### tables=table01 directory=TEST_DIR dumpfile=table01.dmp logfile=expdptable01.log

Export: Release 11.2.0.4.0 - Production on Sun Aug 18 07:14:30 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "USER1"."SYS_EXPORT_TABLE_01": user1/******** tables=table01 directory=TEST_DIR dumpfile=table01.dmp logfile=expdptable01.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-31693: Table data object "USER1"."TABLE01" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01426: numeric overflow<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<Master table "USER1"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for USER1.SYS_EXPORT_TABLE_01 is:
location/table01.dmp
Job "USER1"."SYS_EXPORT_TABLE_01" completed with 1 error(s) at Sun Aug 18 07:14:39 2019 elapsed 0 00:00:06

-bash-4.1$

Changes

 Data redaction policy is applied on the table(table01) in the schema user1

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.