Re: Another curiosity . . .

Ed Stevens wrote:

> 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>
How about because you were granted SELECT on that data dictionary view?

Or how about because there is no public synonym for this view so you must specify the schema owner ...
SYS.DBA_TAB_MODIFICATIONS. Daniel Morgan Received on Thu Mar 06 2003 - 19:46:56 CST