Discrepency between v$rollname and dba_rollbackk_segs???

From: Syltrem <syltrem_at_videotron.ca>
Date: Thu, 15 Feb 2001 10:47:46 -0500
Message-ID: <nOSi6.429$Cx3.5419@wagner.videotron.net>

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

Received on Thu Feb 15 2001 - 09:47:46 CST