Re: X_$ Views

to me these seems to be created by Steve Adam's script. real sys views are x$, steve's script creates new ones as x_$ and then grants privs on those. If this is the case, these x_$ views can be easily dropped and recreated.

Raj

On 9/1/05, LeRoy Kemnitz <lkemnitz_at_uwsa.edu> 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
>
>

--
http://www.freelists.org/webpage/oracle-l