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:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *