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 -- //www.freelists.org/webpage/oracle-l
