ORA-01628

In my years of Oracle DBA work, I’ve seen these two errors confused more times than I can count. Both involve undo. Both appear during long-running operations. Both are blamed on “undo tablespace too small.” But they have fundamentally different root causes, different diagnostic paths, and different fixes. If you treat ORA-01628 like ORA-01555, you’ll… Continue reading