Home » SQL & PL/SQL » SQL & PL/SQL » commit
commit [message #242022] Thu, 31 May 2007 07:10 Go to next message
vkrmhj
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: 4502
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: Fri Dec 09 21:13:48 CST 2016

Total time taken to generate the page: 0.06129 seconds