Re: deleting large number of records from table...

Use this type of delete statement:

Delete from MyLargeTable Where mycol=myval and rownum<1000; Commit;

Run this statement over and over (loop it). The "rownum<1000" will delete the first 999 rows that match your query. Eventually, it will work its way through all the rows using small amounts of rollback.

bill wrote in message <647a9c$s51_at_camel12.mindspring.com>...
>Could anyone give advice for deleting a large number of records from a
>table. I am trying to remove about 1,500,000 records and I am running out
>of rollback space. Would it be better to create a duplicate table
 structure
>and copy the few records to it, then drop the first table?
>
>Thanks in advance for any help.
>Bill
>
>
Received on Mon Nov 10 1997 - 00:00:00 CST