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