Re: NonSystem RBS in SYSTEM tablespace?

Hi Chris,
Apparently they are describing the procedure to create a second tablespace. If you have already done that (and from your post it looks like you did), you shouldn't worry. You should however leave that r0 segment sitting in the system tablespace offline. Never know you need it in maintenance situations.

hth,
Sybrand Bakker, Oracle DBA

chrisoc_at_ans.net wrote:

> 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 - 03:19:52 CDT