rollback segments - AVAILABLE vs. IN_USE ??

From: Chris Little <littlec1_at_jaguar.uofs.edu>
Date: 8 Sep 92 21:34:57 GMT
Message-ID: <1992Sep8.163457.1_at_jaguar.uofs.edu>

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

Received on Tue Sep 08 1992 - 23:34:57 CEST

This message: [ Message body ]
Next message: Dana Uehling - Code 522: "Mac to Oracle interface alternatives"
Previous message: Sundeep Kumar: "Porting Applications written in Ingres/C to Oracle Pro*C"
Next in thread: pihlab_at_hhcs.gov.au: "Re: rollback segments - AVAILABLE vs. IN_USE ??"
Reply: pihlab_at_hhcs.gov.au: "Re: rollback segments - AVAILABLE vs. IN_USE ??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message