Re: commit every x rows (V6)

In article <jdennisCKz8AM.223_at_netcom.com>, jdennis_at_netcom.com (John Dennis) writes:
|>Oh I wish. Ran into same problem. Had to use PL/SQL.
|>BTW, you can't use commit while processing a cursor that was defined
|>as "FOR UPDATE OF column1, column2, ..."! Gives "fetch out of sequence err".
|>
|>John Dennis
|>
|>
|>
|>Steve Corbett (p0070623_at_oxford-brookes.ac.uk) wrote:
|>: 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
|

I call again to you that there's a SET AUTO[COMMIT] {OFF|ON|IMM[EDIATE]} term under SQL*Plus that which seems respond to your problem !!! This controls when ORACLE commits pending changes to the database. ON commits pending changes to the database after ORACLE executes each SQL command or PL/SQL block.
OFF (the default) suppresses automatic committing, so that you must commit changes manually (for example with the SQL command COMMIT). IMMEDIATE functions in the same manner as the ON option. SQL*PLus User's Guide and Reference version 3.0 - page 6-56. Hope this help !

-- 
______________________________________________________________________________

Yves NOEL   -   Database Administrator         
C.I.T.I. (batiment M4)                             Mail  : noel_at_univ-lille1.fr
Universite des Sciences & Technologies de Lille    Phone :    (33) 20.43.42.70
59655 Villeneuve d'Ascq Cedex - FRANCE             Fax   :    (33) 20.43.66.25 
______________________________________________________________________________

   _/_/_/_/    _/_/_/_/   _/_/_/_/   _/_/_/_/             I use ORACLE v6.0.36
  _/_/          _/_/       _/_/       _/_/                         on
 _/_/          _/_/       _/_/       _/_/                 DEC RISC ULTRIX v4.3 
_/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .                       ** 
______________________________________________________________________________