commit every x rows (V6)
From: Steve Corbett <p0070623_at_oxford-brookes.ac.uk>
Date: 9 Feb 1994 11:16:20 -0600
Message-ID: <CKyntr.22x_at_uk.ac.brookes>
Date: 9 Feb 1994 11:16:20 -0600
Message-ID: <CKyntr.22x_at_uk.ac.brookes>
I have some Sql that goes like...
delete table_a;
Space is a bit tight on out test system and i get the error 'failed to extend rollback segment'
Besides writing it in Pl/Sql to build a loop with a commit every x transactions, are there any ways of getting oracle to do a periodic commit?
-- Steve Corbett. vvv [. .] p0070623_at_brookes.ac.uk --------o00-(_)-00o---------Received on Wed Feb 09 1994 - 18:16:20 CET