Re: rollback segments - AVAILABLE vs. IN_USE ??

In article <1992Sep8.163457.1_at_jaguar.uofs.edu>, littlec1_at_jaguar.uofs.edu (Chris Little) writes:
> I'm running Oracle 6.0.33 on a VMS platform. I have a rollback segment,
> rb_A, which is AVAILABLE, but not IN_USE. I have a single tablespace,
> ts_A, which is solely dedicated to rb_A. If I do a SHOW DEVICE/FILE,
> I discover that file_A, which contains only ts_A, is open. Why is it
> open, if rb_A is not IN_USE?
>
> --
> Chris Little, Programmer/DBA University Computing Systems
> University of Scranton
> LITTLEC1_at_JAGUAR.UOFS.EDU Scranton, PA 18510

You've got to reference the new rollback segment in your INIT.ORA file for that database to make it active.

I think the parameter is rollback_segment = rb_A

-- 
Bruce...        pihlab_at_hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************