Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle rollback segment
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> a écrit dans le message
news: 3b1932b2$0$15029$cc9e4d1f_at_news.dial.pipex.com...
> "Anshumn" <anshumn.sagar_at_wipro.com> wrote in message
> news:375b211e.0106020142.1b1ec387_at_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.
Received on Wed Jun 06 2001 - 10:04:24 CDT