Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: commit afer unable to extend rollback segment
straight delete command will not allows you to commit until whole unit work is complete. you may be able to do in a cursor using pl/sql block and using a loop to keep track of rec count and commit your transaction as a small unit of work. This approcah is better than delete command because it place less tool on RBS.
Ted Chyn Received on Sat Oct 18 1997 - 00:00:00 CDT