Re: dba_rollback_segs

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".

DBA_ROLLBACK_SEGS is created by catalog.sql, when you first create the database.
If you need, you could get the creation DDL from there, it seems like somebody dropped the view, or the database was created without running the apporpiate scripts (usualy catalog.sql and catproc.sql)

Bye
I.K. Received on Tue Apr 28 1998 - 18:13:11 CDT