Re: Delete no rollback

Hi Miko,

If you don't want to delete all the rows in the table, try delete with where clause:
and rownum < 1000
this deletes only first 1000 matching rows of the table. Perhaps your rollback segments allows you to use even bigger rownum. You can then repeat this in loop with commit as long as there are no rows to delete.

H

"Miko" <poncz_at_hotmail.com> kirjoitti
viestissä:3b8c19dd.0210010112.61e0b239_at_posting.google.com...
> Can I make a delete query with no rollback?
> I would like to delete 1,000,000 records from my DB but after running
> the delete query my DB returns an error about the rollback.
> I don't want to increase the rollback because I don't want this query
> to rollback.
> Can anyone help me?
>
> Thanks,
> Miko
Received on Wed Oct 02 2002 - 13:42:13 CDT