Hi,
You may write a commit after n number of records,(say 10,000)

/*-------

------------------ COMMITING EVERY 10000 RECORDS --------------------*/
v_Counter := 0;
LOOP
v_Counter := v_Counter + 1;
IF(v_Counter >= 10000) THEN
COMMIT;
v_Counter :=0;
END IF;
END LOOP;
/*--------------------------------------------------------------------------
-*/

Cheers
Biswajit
Union Bank Of India

-----Original Message-----
From: Shailendra
[mailto:oracledba-ezmlmshield-x98446434.[Email address protected]
Sent: Wednesday, September 06, 2006 1:08 PM
To: LazyDBA Discussion
Subject: Update Query



Hi All Gurus,

I need your expertise in this regard. I got a table which contains
millions or
records. I want to update and commit every time for so many records ( say

10,000 records). I don't want to do in one stroke as I may end up in
Rollback
segment issue(s). Any suggestions please ! ! !

Thanks in Advance Waiting for Reply

Regard's


Shailendra Nigam





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page