Xref: utzoo comp.sys.sgi:6905 comp.databases:7890
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!elroy.jpl.nasa.gov!sdd.hp.com!uakari.primate.wisc.edu!dogie.macc.wisc.edu!uwvax!ai.cs.wisc.edu!beverly
From: beverly@ai.cs.wisc.edu (Beverly Seavey)
Newsgroups: comp.sys.sgi,comp.databases
Subject: need help with ORACLE V6.0.27.7.1 on silicon graphics,rollback segs
Message-ID: <11762@spool.cs.wisc.edu>
Date: 19 Nov 90 22:58:29 GMT
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 30

I am trying to add a tablespace to our database ( we have been getting
by with just SYSTEM up until now.)

I was able to create a tablespace using the stamt:

	 CREATE TABLESPACE TS_DAT_2
	 DATAFILE 'TS_FILE_2.DAT' SIZE 10M;

Then, because my understanding is that I need a non-system rollback
segment for a non-system tablespace, I tried to create a rollback
segment for my new tablespace:

	 CREATE ROLLBACK SEGMENT RBS_DAT_2
	 TABLESPACE TS_DAT_2;

ORACLE gives me the following error msg:

 ORA-01552
   cannot use system rollback segment for non-system tables.

 The SQL Error msgs manual advises : Create one or more private or
 public rollback segments, shut down, then start up again. You may need to
 modify the INIT.ORA parameter ROLLBACK_SEGMENTS_REQUIRED to acquire one 
 of the  new private rollback segments.

 This all seems circular: how can I create a rollback segment if oracle
 won't let me? The only INIT.ORA parameter that looked remotely
 relevant is DC_TABLESPACES, which has a default value of 25.

 I am using ORACLE  RDBMS V6.0.27.7.1