RE: System Rollback Segment

Jared, One of my worst vices is reading the documentation. I am not sure if it is in the DOC or not. I know the problem with creating the non-system RBS in the system tablespace for Locally managed Tablespaces was logged as a bug(1176609) and won't be fixed until 9i. I am not sure if this is published bug or not.

Thanks

Scott
> On Mon, 8 Jan 2001 sheisey_at_att.net wrote:
>
> > Jay,prior to version 7.1.6 you always had to create a
> > non-system rollback segment in the system tablespace to
> > create additional non-system rollback segments in
> > non-system tablespaces. However since 7.1.6 Oracle still
> > continued to create the non-system rollback in the system
> > tablespace (in the Oracle generated create DB scripts)
> > even though it is was not needed. However since the
> > introduction of locally managed tablespaces you end with
> > the same problem you have always had prior to 7.1.6. This
> > means if you create a locally managed RBS tablespace in
> > 8i you will have to create a non-system RBS in the system
> > tablespace to create additional non-system RBS's in the
> > locally managed RBS tablespace. If you still use
> > Dictionary managed RBS tablespaces in 8i then you do not
> > need to create the non-system RBS in the system
> > tablespace. Hope this makes sense.
> >
> > Scott
>
> Thanks for the info Scott.
>
> Is this in the std documentation?
>
> Jared Still
> Certified Oracle DBA and Part Time Perl Evangelist ;)
> jkstill_at_teleport.com
> jared_still_at_enron.net
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: jared still
> INET: jkstill_at_teleport.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Mon Jan 08 2001 - 12:28:44 CST