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
> I do not how that got started that it is necessary to create an additional
> RBS in system. I know from
> 7.x to the present it is not necessary.
>
> Rick
>
> > -----Original Message-----
> > From: Jay Hostetter [SMTP:jhostetter_at_decommunications.com]
> > Sent: Monday, January 08, 2001 8:55 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: System Rollback Segment
> >
> > I know I risk embarrasment by asking a question on a Monday morning, but
> > here goes... When creating a database, it is standard procedure to create
> > an additional rollback segment in the system tablespace so that you can
> > create additional objects (I think it is the ORA-1552 error that you get
> > if you don't do this). Today I was examining scripts that were generated
> > by dbassist for an 8.1.6 database (on Comaq Tru64). I notice that these
> > scripts do NOT create an additional rollback segment in the system
> > tablespace. They run catalog.sql, then begin adding tablespaces, etc. My
> > question is - Did something change along the way (from 7.3 to 8.x) that
> > this additional rollback segment is no longer needed? I haven't been able
> > to find anything on MetaLink.
> >
> > Thanks
> >
> > Jay Hostetter
> > Oracle DBA
> > D. & E. Communications
> > Ephrata, PA USA
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jay Hostetter
> > INET: jhostetter_at_decommunications.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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
Received on Mon Jan 08 2001 - 09:45:50 CST
