Re: Delete no rollback

"Miko" <poncz_at_hotmail.com> wrote in message news:3b8c19dd.0210010112.61e0b239_at_posting.google.com...
> Can I make a delete query with no rollback?

No.

> 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.

Rollback segments are used for 2 purposes.

1. To rollback the transaction either under your control of if the db dies meantime.
2. To construct read-consistent images of data.

You need that rollback for a delete

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************