FreeLists / oracle-l / Re: X_$ Views

[Paul Drake <bdbafh@xxxxxxxxx>]

On 9/1/05, LeRoy Kemnitz <lkemnitz@xxxxxxxx> wrote:
> 
> 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.



Funny, I hit this same thing today, upgrading an old 8.1.7 db to 10.1.
The ixora scripts weren't hard-coded, they were based off of 

sys.v_$fixed_table and sys.v_$fixed_view_definition.

There was a spool file for that ... but that server has long since been 
retired.
Guess I could point it back at a sterile 8.1.7 db, see what it creates and 
drop those objects.
One of those views - X_$CLASS_STAT is throwing ora-600 [16206] and I'm not 
too fond of those.

Then again, I'm not that fond of dropping sys objects either.

Paul

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> 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
> 
> 


-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.