From: "Gildas COTOMALE" <gcotomale@kleegroup.fr>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Oracle rollback segment
Date: Wed, 6 Jun 2001 17:04:24 +0200
Organization: Klee
Lines: 25
Message-ID: <9flgjg$ba4$1@klin.lan.klee.fr>
References: <375b211e.0106020142.1b1ec387@posting.google.com> <3b1932b2$0$15029$cc9e4d1f@news.dial.pipex.com>
NNTP-Posting-Host: gcotomale.lan.klee.fr
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


"Niall Litchfield" <niall.litchfield@dial.pipex.com> a écrit dans le message
news: 3b1932b2$0$15029$cc9e4d1f@news.dial.pipex.com...
> "Anshumn" <anshumn.sagar@wipro.com> wrote in message
> news:375b211e.0106020142.1b1ec387@posting.google.com...
> > Hi,
> >
> > Need some input regarding Oracle Rollback Segment.
> >
> > Due to the Rollback segment size restriction, the deletion of the
> > records is failing. Now one way to solve this is to increase the size
> > of
> > the rollback segment.
> > The other way is to use 'TRUNCATE' to delete the records. But in my
> > case, I want to delete specific records based on the specified
> > condition. So can some condition be used with the TRUNCATE clause? I
> > checked it up, it is not allowing...any other way to do it ?
>
> Correct "TRUNCATE TABLE WHERE ..." is not valid.
> >
In another way, TRUNCATE is an autocommited command.
To use conditions (WHERE), use the DELETE statement.