Re: X_$ Views

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 1 Sep 2005 08:57:24 -0700
Message-ID: <bf463805090108577944880@mail.gmail.com>

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 

> 

> 

> 

>


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

Received on Thu Sep 01 2005 - 11:52:42 CDT