ORA-31693, ORA-02354 and ORA-01555 with Export Datapump (Doc ID 1580798.1)

Last updated on JULY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.2.0.1 [Release 10.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Using Database Data Pump (expdp), one table fails to export with the following errors:

ORA-31693: Table data object "APPLSYS"."FND_LOBS" 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 with name "" too small
ORA-22924: snapshot too old

 Followed the steps in Note:452341.1 and/or Note:787004.1, and found that there is no LOB corruption.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms