Re: Deleting Large number of Rows

Hi,

    If you are trying to get rid of all the rows, use truncate.

    Another way to do batches is:

    delete from <table> where rownum <= 5000;     commit;

    Use that in place of each group.

Mike Stout Received on Fri Feb 19 1999 - 18:29:17 CST