RE: Discrepency between v$rollname and dba_rollbackk_segs???

From: David Fitzjarrell <ddf_dba_at_MailAndNews.com>
Date: Thu, 15 Feb 2001 11:05:38 -0500
Message-ID: <3A9AC8D1@MailAndNews.com>

>===== Original Message From "Syltrem" <syltrem_at_videotron.ca> =====
>How could this happen?
>Was there someone who asked the same thing not so long ago? I think I
>remember seing this but I did not read the thread since it did not occur to
>me that I could have odd problems like this... And I don`t keep messages
>long enough to look back a week or two in the past.
>
>SQL> select segment_name from dba_rollback_segs;
>
>SEGMENT_NAME
>------------------------------
>SYSTEM
>R01
>R02
>R03
>RBBTMP
>
>SQL>
>select name from v$rollname;
>
>NAME
>------------------------------
>SYSTEM
>R01
>R02
>R03
>
>
>
>--
>
>Sytrem
>http://pages.infinit.net/syltrem
>
>

select segment_name from dba_rollback_segs where status = 'ONLINE';

You should find the list from the above query matches the list from v$rollname.

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Thu Feb 15 2001 - 10:05:38 CST