Monday , December 4 2023

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 and The problem is corrected as of version

For the solution of the problem;

You can apply patch 14405152.


You can run expdp with ACCESS_METHOD = EXTERNAL_TABLE.



About 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 *