Data Pump Export Fails With ORA-31693 ORA-02354 and ORA-01555 Errors And No LOB Corruption
Last updated on JUNE 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
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-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.
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