Re: unlimited_rollback_segments = no maxextents?

From: John Chiu <johnymc_at_netscape.net>
Date: Sun, 31 Oct 1999 15:23:07 -0500
Message-ID: <7vi8er$fmr$1@news2.tor.accglobal.net>

Try

     create rollback segment rbsname
               tablespace tablespacename
               storage ( initial x m
                             next x m
                             optimal x m
                             minextents 2
                             MAXEXTENTS UNLIMITED)

HTH John Chiu

<alan_psb_at_yahoo.com> wrote in message news:7vh9gj$3ed$1_at_nnrp1.deja.com...
>
>
>
> What parameters should I set such that there is no limitation of the
> maxextents on Oracle 7.3, NT server version? Someone suggests that
> setting unlimited_rollback_segments can do that. However, after I set
> this parameter to TRUE on initsid.ora, the maxextents still reached. Is
> there parameter which related with the maxextents? And what is the use
> of unlimited_rollback_segments?
>
> Thanks,
> Alan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 31 1999 - 14:23:07 CST