Re: Can't delete 60000 records at a time

Alternatively, write a small stored procedure to remove the records in batches.

If you are using this command:

>set transaction use rollback segment ???;

always do a COMMIT; before it as this will force your session to clear any active transactions from rollback before you start the delete.

Regards

Chris. Received on Wed May 20 1998 - 00:00:00 CDT