Truncate vs Delete Here I compare the differences between TRUNCATE and DELETE an entire table in the following chart. Question Truncate Table Delete From DDL… Read More »Truncate vs Delete
ORA-01555 UNDO_RETENTION Let's see the error ORA-01555 UNDO_RETENTION first: Description ORA-01555: snapshot too old: rollback segment number string with name "string" too small Cause rollback… Read More »How to Resolve ORA-01555 UNDO_RETENTION
UNDO_RETENTION At times, you may find out or feel that UNDO_RETENTION is useless at all. Raising the number of seconds cannot resolve ORA-01555. This is… Read More »UNDO_RETENTION, How and Why