My Oracle Support Banner

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

Last updated on AUGUST 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

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

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
Changes
Cause
Solution
References

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