Re: Delete no rollback

Miko,

English usage hint: instead of saying 'query' as in 'DELETE query', 'INSERT query', it is better to use the word 'statement' or 'operation'. The word 'query' means data retrieval using the SELECT statement.

If you want to delete all the rows from a particular table, you could use the DDL statement 'TRUNCATE TABLE' which does not use rollback.

Martin Doherty

Miko wrote:

> 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