ORA-01555

RA-01555 is one of the most mishandled errors in Oracle production support. The fix is almost always “increase undo retention” — and teams apply it, the error goes away for a while, and eventually it comes back. This cycle repeats because the team is treating the symptom. The error comes back because the root cause… Continue reading

You may hit with that error code during the export process. I faced with those error on Oracle 12c database. Complete error messages are: ORA-31693: Table data object “SCHEMA”.”TABLE_NAME_HERE” 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 21 with name “_SYSSMU21_2773200038$”… Continue reading