Re: How to connect another tablespace?

> The first thing you need to do, if you haven't already, is create a second
> rollback segment in the SYSTEM tablespace. When you create a database,
> only one rollback segment is created. This rollback segment is only for
> activity in the SYSTEM tablespace. You can create other tablespaces, but
> cannot use them until you create a second rollback segment.
>

FYI: Oracle creates TWO cdrb scripts the first of which creates a rollback segment called R0 in the RBS tablespace. When the create database is completed, a second script generally called "crdb2$ORACLE_SID.sql" is run to create the other three rollback segments. You wind up with a total of 4 rollback segments at the end of any Installer session.

Jim Joslin
BST - DBA/Product Support Received on Fri Nov 03 1995 - 00:00:00 CET