Re: dba_rollback_segs

Hi,
you should be able to see it like this: select * from sys.dba_rollback_segs. To avoid having to use the prefix, you must run the
script catdbsyn.sql under this user (you'll find the script in ORACLE_HOME/RDMBSxx/ADMIN

Hope this helps,
--
Pavel Polcar

Joe W <falon_at_onramp.onramp.onramp.net> wrote in article <5DAF3EBA9C017DD8.DC7D8338C835CA52.BA99906C6A84B5CA_at_library-proxy.airnews.ne t>...
> hello -
> when I try to see the status of all rollback
> segments, using:
> select segment_name, status from dba_rollback_segs;
> I get "ORA-00942: table or view does not exist".
> I have the following privileges:
> connect,
> dba,
> exp_full_database,
> imp_full_database,
> resource.
> Am I missing something?
> BTW, I can use
> select * from v$rollname;
> to see the rollback segments that are online.
>
> thanks for the help.
> "you're not a nerd till you hava network in your living room"
> -some guy at a trekcon--
> falon_at_onramp.onramp.onramp.net
> (please remove all but one 'onramp' for email address)
>
Received on Wed Apr 29 1998 - 01:23:15 CDT