Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: Delete rows (not delete all of table)

    I am trying to delete 600000 rows of a table with 10000000 records, I used "delete" command It took long more than 6 hrs, is there alternative way to do that faster.
    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Delete rows (not delete all of table)

    Export the rows you want to keep and then do a LOAD Replace.

    HTH

    Cheers

    Sathyaram
    Originally posted by David2002
    I am trying to delete 600000 rows of a table with 10000000 records, I used "delete" command It took long more than 6 hrs, is there alternative way to do that faster.
    Thanks

  3. #3
    Join Date
    Sep 2002
    Location
    Wisconsin
    Posts
    37
    Select and reload 9.4m rows??? That's going to take some time and cause disruptions. What is current commit ratio and who else is using the table?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    ooops ... i read it as 1,000,000 .... (

    sorry about that ...

    Another way can be to create a table similar to the orginal with NOT LOGGED INITIALLY option and do a INSERT into newtab select * from orgtable <where-clause> , drop the original table and rename the newtable.

    Or do a row-by-row delete using a cursor and commit every 'n' rows ..

    mmm ... Good luck ...


    Originally posted by Balr14
    Select and reload 9.4m rows??? That's going to take some time and cause disruptions. What is current commit ratio and who else is using the table?
    Last edited by sathyaram_s; 09-24-02 at 18:34.

  5. #5
    Join Date
    Jul 2002
    Posts
    86
    Thank you so much it is working.
    David2002

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    David .... Its nice that you posted feedback on your problem resolution ...

    But, unfortunately, it is not clear as to which approach worked well for you .

    Please can you clarify this for the group.

    Cheers

    Sathyaram

    Originally posted by David2002
    Thank you so much it is working.
    David2002

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •