Re: X_$ Views

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

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