Data Pump Export Fails With ORA-31693 ORA-02354 and ORA-01555 Errors And No LOB Corruption (Doc ID 1507116.1)

Last updated on MARCH 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2014***

Symptoms

You are exporting your applications database using Data Pump (expdp), and all is exporting fine, except 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 154 with name "_SYSSMU154_1434655980$" too small


You suspected that you may have had LOB corruption and followed the steps from <Note:452341.1> or <Note:787004.1>, but no corruption is found in the LOB.

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