FreeLists / oracle-l / Re: X_$ Views

[LeRoy Kemnitz <lkemnitz@xxxxxxxx>]

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@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@xxxxxxxx 
> <mailto:lkemnitz@xxxxxxxx>> 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