Re: Delete no rollback

From: Kevin Gillins <k.gillins_at_verizon.net>
Date: Wed, 2 Oct 2002 07:27:08 -0400
Message-ID: <anelfm$8i3$1@nntp-m01.news.aol.com>

If the 1,000,000 records (rows) represents all of the data in the table and there is no referential integrity constraints, look at the truncate command.

If you have a where clause on your delete then the truncate command is not for you. If you are using conditions, then you may need to have a procedure with commits after some row count.

Kevin

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3D99C27F.D10EFA76_at_exesolutions.com...
> 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
>
> No.
>
> The problem you are having has nothing to do with the delete query
> itself. It has to do with the rollback segments. They need to be larger.
>
> In the future be sure you post hardware, operating system, oracle version
> and edition, and the exact Oracle ORA-##### error message and text for
> help.
>
> Daniel Morgan
>
Received on Wed Oct 02 2002 - 06:27:08 CDT