Re: How to clear Rollback segments

Ron Reidy <rereidy_at_indra.com> wrote in message news:<3C0C66DF.744526F5_at_indra.com>...
> Ganesh Raja wrote:
> >
> > Yurasis Dragon <yurasis_spamNOSPAM_at_yahoo.com> wrote in message news:<kq1o0ukq2fmrb2tft38dv32ncmace2njem@4ax.com>...
> > > Hmmm, not sure that it'll fix any "slow" problems but here's the syntax :
> > >
> > > alter rollback segment <WHATEVER> shrink;
> >
> > But how do u resize the file after shrinking the same.
> >
> > >
> > >
> > > Through spittle and decaying teeth, "Michael Buresch" <michael.buresch_at_t-online.de> grunted once then squawked :
> > >
> > > >Hallo,
> > > >
> > > >I have very big system rollback segments. How can I clean or reset it. My
> > > >system is very slow and it seems that that is the problem.
> > > >
> > > >Best regards,
> > > >Michael
> > > >
> ALTER DATABASE DATAFILE '<file name goes here>' SIZE <new size goes
> here>

But This Refuses to resize the file it says that Data beyond requested size. Comments ? Received on Wed Dec 05 2001 - 08:03:31 CET