RE: System Rollback Segment

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).
Received on Mon Jan 08 2001 - 08:40:08 CST