ORA-31693: Table data object failed to load/unload and is being skipped due

Problem:

You are getting ORA-31693 and ORA-02354 when running expdp

Error message:

ORA-31693: Table data object "HR"."EMP" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-01426: numeric overflow

Oracle Data Pump (expdp and impdp)

There are only few steps required to run a Data Pump export/import utility job:

  1. Create Oracle database directory and OS directory with write/read access.

  2. Grant read and write privileges on the directory object to the database user running the export.

  3. Run expdp/impdp