ORA-01426 numeric overflow Error When Trying to get backup with Expdp

 

When you try to get a backup with Expdp, if the process ends with error ORA-01426: numeric overflow, there are some alternative solutions.

During the process, the following error will occur and expdp will terminate.

This error is seen in versions between 11.2.0.1 and 11.2.0.3. The problem is corrected as of version 11.2.0.4.

For the solution of the problem;

You can apply patch 14405152.

or

You can run expdp with ACCESS_METHOD = EXTERNAL_TABLE.

Example: