Re: Another curiosity . . .

Hi!

At least in my test 8.1.7.1 installation, there's no synonym on the table..

SQL> select owner, object_Type from dba_objects where object_name = 'DBA_TAB_MODIFICATIONS';

OWNER                          OBJECT_TYPE
------------------------------ ------------------
SYS                            VIEW

Tanel.

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:3clf6v0o3p4pg7qgk8507stmrt8kac5utr_at_4ax.com...
> Oracle 8.1.7
>
> Check this short session transcript. Why can I select from DBA_VIEWS,
> but not DBA_TAB_MODIFICATIONS?
>
> SQL> connect system/****
> Connected.
> SQL> select view_name from dba_views where view_name like '%TAB_MOD%';
>
> VIEW_NAME
> ------------------------------
> ALL_TAB_MODIFICATIONS
> DBA_TAB_MODIFICATIONS
> USER_TAB_MODIFICATIONS
>
> SQL> desc DBA_TAB_MODIFICATIONS
> ERROR:
> ORA-04043: object DBA_TAB_MODIFICATIONS does not exist
>
>
> SQL> desc sys.dba_tab_modifications
> Name Null? Type
> ----------------------------------------- --------
> --------------------
> TABLE_OWNER VARCHAR2(30)
> TABLE_NAME VARCHAR2(30)
> PARTITION_NAME VARCHAR2(30)
> SUBPARTITION_NAME VARCHAR2(30)
> INSERTS NUMBER
> UPDATES NUMBER
> DELETES NUMBER
> TIMESTAMP DATE
> TRUNCATED VARCHAR2(3)
>
> SQL> select owner, view_name from dba_views where
> view_name='DBA_VIEWS';
>
> OWNER VIEW_NAME
> ------------------------------ ------------------------------
> SYS DBA_VIEWS
>
> SQL>
Received on Fri Mar 07 2003 - 04:07:11 CST