Re: Another curiosity . . .

problem of privileges, or synonym does not exist on the DBA_TAB_MODIFICATIONS
view...

Céline.

"Ed Stevens" <nospam_at_noway.nohow> a écrit dans le 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 - 03:44:18 CST