Skip to Main Content

Database Software

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-31693 - ORA-02354 - ORA-01555

user258571Nov 30 2011 — edited Dec 14 2011
Hi,
in my db 11.2 when i try to expdp a table with a clob column (the lobsegment is about 30Gb) i raise these errors:
ORA-31693: Table data object "USER"."T_ABLE" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_1146664900$" too small
I've tried to check lob corruption, see note 787004.1, but does not seem to be problems.
The procedure in note 787004.1 is very slow!
Some ideas?

Tnx
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2012
Added on Nov 30 2011
13 comments
14,088 views