Re: NonSystem RBS in SYSTEM tablespace?

Hi Chris,
I think what they were trying to tell you is that when creating any database you must have a non-system rollback segment on-line prior to creating any additional tablespaces. What you will need to do is create this rollback segment in SYSTEM, create your other tablespaces including one specifically for rollback segmetns. Once this is done you can take the non-system rollback off-line in the system tablespace. Many DBA's take this tablespace offline but leave it there in case they run into a problem later.

Hope this helped and didn't confuse the issue.

Jed Sousa
Database Administrator
Database Technologies Inc.
Wellesley Hills, MA

chrisoc_at_ans.net wrote in article <6tboqu$705$1_at_nnrp1.dejanews.com>...
> I'm going to install Remedy ARS with a supporting Oracle database.
> It's a help desk/trouble ticketing application.
>
> In the Remedy ARS docs, there is a sentence asking me to first
> "ensure that a nonsystem rollback segment has been created
> in the system tablespace and brought online. ... also add it
> to your init<SID>.ora file .."
>
> I really don't want to put RBS active segments in the SYSTEM
> tablespace. I like them in their own RBS tablespace.
>
> Has anyone bumped into a similar requirement ... maybe I am
> misreading the instruction. I don't think any application should
> care where the RBSes live, just that they work all right.
>
> In fact our database creation scripts do make an "r0" in SYSTEM
> but they take it off line as soon as 4 others are made, in RBS.
>
> Chris O'Connor
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Sat Sep 12 1998 - 10:26:49 CDT