Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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.
1 2 | ORA-02354: error in exporting/importing data ORA-01426: numeric overflow |
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:
1 | expdp hr DIRECTORY=dpump_dir1 DUMPFILE=expdat.dmp SCHEMAS=hr ACCESS_METHOD=EXTERNAL_TABLE |
