|
[oracle-l]
||
[Date Prev]
[09-2005 Date Index]
[Date Next]
||
[Thread Prev]
[09-2005 Thread Index]
[Thread Next]
Re: X_$ Views
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: lkemnitz@xxxxxxxx
- Date: Thu, 01 Sep 2005 09:38:06 -0600
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
|
|
