Re: millions update

Seema,

If you truly want to learn how to do things, try them yourself.

I say this only because you already have outlined a solution to your question, you just need to test it.

Keep track of timing and database statistics while processing the rows in chunks of differing sizes.

All on a test system of course. :)

Jared

On Fri, 22 Oct 2004 01:12:55 -0400, Seema Singh <oracledbam_at_hotmail.com> wrote:
> Hi,
> I want to update millions of row.How to update in batch of 1000 rows
> Is following pl/sql ok?
> declare
> i pls_integer;
> begin
> i := 1000;
> while i = 1000 loop
> UPDATE MESSAGES set id=44178 where desc_code='F086' and id=33167 and
> rownum <1001;
> i := sql%rowcount;
> commit;
> end;
>
> thanks
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l