Re: Delete no rollback

Also, read this FAQ article:

http://www.jlcomp.demon.co.uk/faq/truncate.html

Martin Doherty wrote:

> 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