Viewing entries tagged
ORA-01555

Comment

2011-05 – Snapshot Too Old / Commits within a Loop

Ever run into the dreaded ORA-01555 error?  It usually happens eight hours into your ten hour ETL run.  With automatic undo management in Oracle 9i, this happens less often, but can still be a major headache.  So you look at your ETL to try to find ways to improve and discover code like this:

 

 

Comment