Re: dba_rollback_segs

The dba_rollback_segs is a SYS view. You may try prefixing with SYS. If it works you know that the synonyms were not created. You need to run CATDBSYN.SQL from your rdbmsXX\admin directory.

Good luck,
CM

In article
<5DAF3EBA9C017DD8.DC7D8338C835CA52.BA99906C6A84B5CA_at_library-proxy.airnews.net> #1/1,
  falon_at_onramp.onramp.onramp.net (Joe W) wrote:
>
> 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)
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 12:44:52 CDT