Instead of that, you can create table as select from original table with
keep rows and get rid of unwanted table..so that it will be more efficient!!
>From: "mitchell" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: delete and commit
>Date: Thu, 29 Aug 2002 15:40:59 -0400
>
>Hi
>
>I have a table of 10 million rows and I want to delete about 3 millions
>If
>I want to delete every 1000 rows and commit then start over unitll all.
>
>Any hint how to do this.
>
>This is my sql.
>
> delete STATEMENT_LiNE
> WHERE rownum < 1000 and stmt_seq in
> (select stmt_seq from STATEMENT_HEADER
> where to_date(stmt_date,'DD-MON-YYYY') <=
>to_date('01-JAN-2000','DD-MON-YYYY')) ;
>
>
>Thanks in advance
>
>Mitchell
>
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html




_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx

Oracle LazyDBA home page