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

Because DBA_ views will tell you all rollback segments that exist, whatever their status. And the V$ views will only tell you about those rollback segments which are actually online. I would imagine, therefore that RBBTEMP has been taken offline at some point.

Regards
HJR "Syltrem" <syltrem_at_videotron.ca> wrote in message news:nOSi6.429$Cx3.5419_at_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 - 17:19:06 CST