Skip to Main Content

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!

EXPDP fails with ORA-31694, ORA-31693, ORA-02354 and ORA-06550

user82929Oct 6 2010 — edited Feb 21 2011
When attempting to datapump export multiple schemas at a client's 11gr2 db on windows 2k8, i'm getting the folllowig errors.


ORA-31693: Table data object "REDACTEDTABLENAME" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-06550: line , column :

ORA-31694: master table "SYSTEM"."SYS_EXPORT_SCHEMA_09" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-06550: line , column :

i've been able to export schemas there in the past and EXP worked without error. also any table with 0 rows was successfully exported from this same schema. I can't seem to find this particular combination mentioned anywhere. Does anyone have any ideas?

thanks in advance,
John Reynolds
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2011
Added on Oct 6 2010
7 comments
4,366 views