Re: millions update
- From: Jared Still <jkstill@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Fri, 22 Oct 2004 10:11:58 -0700
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@xxxxxxxxxxx> 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/
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
