Re: How to increase MAX EXTENTS?

One think to add here is you need the init parameter COMPATABLE=7.3.4 (or whatever it is)

Frank van Bortel <f.van.bortel_at_vnl.nl> wrote in message news:388F882F.105E065B_at_vnl.nl...
> Roger Arnesen wrote:
>
> > I have run into a problem with an app that uses Personal Oracle 7.3.x,
 which
> > is an errormessage saying that I have reached the max extents allowed
 (121)
> >
> > The segment_type is "ROLLBACK", the segment name is "RB2"
> >
> > How do I fix this??
> >
> > Roger
>
> For 7.3.4 you can add unlimited_rollback_extents = true to your init.ora
> and change to unlimited extents (alter tablespace rollback default storage
> (maxextents unlimited))
> At the same time, I'd introduce autoextending the datafile.
> Not sure what option was introduced in what version, maybe unlimited
> rollback is in 733, too
> HTH
> --
> Met vriendelijke groet/kind regards,
>
> Frank van Bortel
> Technical consultant Oracle
>
>
Received on Tue Feb 01 2000 - 00:00:00 CST