Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Another curiosity . . .
And you know this how? --
"EpiteamB" <carmanetREM_at_epicentre.fr> wrote:
>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 - 09:30:38 CST