Re: X_$ Views

I dropped and recreated the views and now have these invalid after running the utlrp.

SYS          DBMS_XMLQUERY                  PACKAGE BODY       INVALID
SYS          X_$KCBBMC                      VIEW               INVALID
SYS          X_$KCLUH                       VIEW               INVALID
SYS          X_$KCLUI                       VIEW               INVALID
SYS          X_$KLLCNT                      VIEW               INVALID
SYS          X_$KLLTAB                      VIEW               INVALID
SYS          X_$KSXTMPT                     VIEW               INVALID
SYS          X_$TRACES                      VIEW               INVALID
UWSDDH       IPEDS                          PROCEDURE          INVALID

I don't believe any other outside software is installed but can't guarantee it.

Jared Still wrote:

> These views are created by the create_xviews.sql script as
> found at Steve Adam's site: ixora.com.au <http://ixora.com.au>.
>
> Oracle does not create any such views.
>
> Try the following bit of SQL and you will likely see that there
> is a X$BH public synonym pointing to the X_$BH view.
> These are also created by create_xviews.sql.
>
> 1 select
> 2 owner,
> 3 table_owner,
> 4 synonym_name,
> 5 table_name,
> 6 db_link
> 7 from dba_synonyms
> 8 where synonym_name like 'X$BH'
> 9* order by owner, table_owner, synonym_name
> 08:55:33 hudson - jkstill_at_ts71 SQL> /
>
> SYNONYM TABLE
> OWNER OWNER SYNONYM
> TABLE DATABASE LINK
> ---------- ---------- ------------------------------
> ------------------------------ ------------------------------
> PUBLIC SYS X$BH X_$BH
>
>
>
> 1 row selected.
>
> You could likely clear this up by re-running create_xviews.sql.
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
> On 9/1/05, *LeRoy Kemnitz* <lkemnitz_at_uwsa.edu
> <mailto: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
>
>
>
>
>
>

-- 
LeRoy Kemnitz
UW System Administration
Database Administrator
780 Regent Street, #246
Madison, WI 53714
Phone: (608) 265 -5775
Fax: (608) 265 - 2090


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