ORA-01555: SNAPSHOT TOO OLD ERROR BECAUSE OF LOB CORRUPTION

How to identify rows with corrupted LOBs by scanning a table. SYMPTOMPS When attempting to export tables that contain lobs, the following errors occur: ORA-01555: snapshot too old: rollback segment number with name “” too small SOLUTION Usually, the ORA-01555 error is related to both … Continue reading ORA-01555: SNAPSHOT TOO OLD ERROR BECAUSE OF LOB CORRUPTION