Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: commit afer unable to extend rollback segment

Re: commit afer unable to extend rollback segment

From: Tlcbus <tlcbus_at_aol.com>
Date: 1997/10/18
Message-ID: <19971018155001.LAA17982@ladder02.news.aol.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US