Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dba_rollback_segs

Re: dba_rollback_segs

From: Bruno Kamiche <bkamiche_at_sanmiguelind.com.pe>
Date: Tue, 28 Apr 1998 16:26:35 -0500
Message-ID: <6i4ekv$cfi$1@manu.unired.net.pe>


You have to run the catdbsyn.sql file

Joe W wrote in message
<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 Tue Apr 28 1998 - 16:26:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US