What is the error you receive when your update statement fails ?


-----Original Message-----
From: somasekhar
[mailto:oracledba-ezmlmshield-x77766082.[Email address protected]
Sent: Monday, December 27, 2004 1:28 AM
To: LazyDBA Discussion
Subject: updating a table in batch mode for n number of records..


Hi All,

I have a table with 2 million records, Right now , when I run an update
query the whole table gets locked and after some time the query abends
without updating the values , this update statement is run the batch
mode. it has to update all the 2 million records. Is it possible to
update only couple of records at a time for example first 100 records
and then the next 100 records till 2 million.

I request you all DBA is there an query which can do this kind of
operation.

Thanks in advance
-Som




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page