Home » SQL & PL/SQL » SQL & PL/SQL » commit
commit [message #242022] Thu, 31 May 2007 07:10 Go to next message
Messages: 9
Registered: May 2007
Junior Member
I have selected a few million records in a cursor and commiting after updating 2000 records.I can get some rollback segment error due to this.Is there any alternative other than increasing the rollback tablespace or updating every 2000 records.
Thanks in advance..
Re: commit [message #242023 is a reply to message #242022] Thu, 31 May 2007 07:26 Go to previous message
Frank Naude
Messages: 4509
Registered: April 1998
Senior Member
See http://www.orafaq.com/faq/how_often_should_one_commit_in_a_pl_sql_loop_what_is_the_best_commit_strategy
Previous Topic: Selecting duplicate values
Next Topic: Compress pages and the truncate free spaces
Goto Forum:

Current Time: Thu Jul 27 17:54:31 CDT 2017

Total time taken to generate the page: 0.21525 seconds