Re: Help: select on x$kcbfwait

Mike F wrote:
>
> one of our script needs to select against x$kcbfwait as system. Some
> of our database is OK to run it, some of the database can not select
> against x$kcbfwait as system.
> When I issue "grant select on x$kcbfwait to system" as sys,
> I got
>
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>
> Why some other databases can let system to select? How can I grant
> select on x$kcbfwait to system?
>
> Thanks
>
>
>
> --
> Sent by dbadba62 from hotmail part from com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

create view y$any_x_dollar_table as select * from x$any_x_dollar_table

and then you can select from 'y$any_x_dollar_table'

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."