Re: X_$ Views

In your original not you said v_$ views, but these are x_$ views. They are not Oracle delivered. A statspack install creates some of them, but last time I looked it only creates 3 or 4. Do you have a 3rd party monitoring tool installed (spotlight, patro, ...). They sometimes create those views because you can't grant directly to the x$ tables. I do the same every time I create a database: create x_$ views, grant select on them to a role and create public x$ synonyms so I can give access to x$ "tables" to non-sys userids. I have upgraded 9.2.0.6 databases with these views created successfully to 10.1.0.4. Of course, none of them were invalid.

LeRoy Kemnitz wrote:
> SYS DBMS_XMLQUERY
> SYS X_$BH
> SYS X_$CKPTBUF
> SYS X_$KCBBF
> SYS X_$KCBBMC
> SYS X_$KCBSC
> SYS X_$KCBSH
> SYS X_$KCBSW
> SYS X_$KCBWBPD
> SYS X_$KCBWDS
> SYS X_$KCCCP
>
> SYS X_$KCLCRST
> SYS X_$KCLFH
> SYS X_$KCLLS
> SYS X_$KCLUH
> SYS X_$KCLUI
> SYS X_$KCRFX
> SYS X_$KJILKFT
> SYS X_$KJIRFT
> SYS X_$KJITRFT
> SYS X_$KLLCNT
> SYS X_$KLLTAB
>
> SYS X_$KSXTMPT
> SYS X_$LE
> SYS X_$LOGMNR_CONTENTS
> SYS X_$TARGETRBA
> SYS X_$TRACE
> SYS X_$TRACES
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l