Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Grant SYS.x$KCCCP to DBA..........................
Thanks,
Is creating a view on fixed tables is the only solution for my query?
Should the view which we created for the fixed table SYS.x$KCCCP
refresh implicitly?
By default is there an alternative view of this fixed table
SYS.x$KCCCP available, if so what is that view.
Yes the column CPODR_BNO is what I am looking for. Actually I want to find out the amount of redo generated for the current redo log file.
Thanks
Marjina
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<412b2722$0$14187$afc38c87_at_news.optusnet.com.au>...
> marjina98_at_hotmail.com wrote:
>
> > Hi,
> >
> > How should we grant SYS.x$KCCCP to DBA?
> > I am using following command to grant SYS.x$KCCCP to DBA but getting
> > the following error:
> >
> > *
> > ERROR at line 1:
> > ORA-02030: can only select from fixed tables/views
> >
> > I am using version 8.1.7.0.
> >
> >
> >
> > Thanks
> >
> > Marjina
>
> The real question is not "how", but "why".
>
> What is in that table that you think someone needs constant access to? I can
> think of nothing but CPODR_BNO... and I can't imagine for one minute what
> possible use it could be to any DBA to know that information on a regular
> basis!
>
> Regards
> HJR
Received on Wed Aug 25 2004 - 03:22:35 CDT