Data Pump Export Fails With ORA-31693 ORA-02354 and ORA-01555 Errors And No LOB Corruption
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***
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