System Rollback Segment

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Mon, 08 Jan 2001 08:49:43 -0500
Message-Id: <10735.125963@fatcity.com>

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 Received on Mon Jan 08 2001 - 07:49:43 CST