Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Another curiosity . . .
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
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 Thu Mar 06 2003 - 17:16:09 CST