Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Mitesh ShahSep 29 2014 — edited Sep 29 2014

By using the export dump utility "expdp system/ora11g DUMPFILE=scott.dmp DIRECTORY=data_pump_dir SCHEMAS=scott reuse_dumpfiles=y", I am facing following issue

ORA-31693: Table data object "SCOTT"."DEPT" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-06550: line , column :

To resolve this issue I have uninstalled Oracle software and installed Oracle 11.1.0.7 with Patch 22 but still facing the same issue.

Also I noticed all tables with 0 rows are exported successfully but facing above same issue with all tables having more than 1 rows.

Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 27 2014

Added on Sep 29 2014

#general-database-discussions

3 comments

3,344 views