Rollback Segment Errors
Date: Fri, 27 Jun 2003 04:37:37 GMT
Message-ID: <lSPKa.28822$3d.17163_at_sccrnsc02>
Is their anyway to perform mass deletes (several million records) without
"maxing out" rollback segments?
I'm working on archiving data from an Oracle 8.1.7 database The system is
about 4 years old and no data has EVER been archived /removed. So the
two largest tables contain well over 25 million records!
As part of the archive process I'm deleting out-dated records, but because
of the sheer volume keep receiving "Unable to extend Rollback Segment
errors." I've tried to commit every 50 deletes, I've even tried committing
every single delete, but eventually always receive this error. Our DBA
does not want to extend the rollback segments (probably with good reason).
This process will run off-hours, so there's no conflict with end-users.
TIA for any insights you can provide.
Tomas
Received on Fri Jun 27 2003 - 06:37:37 CEST