Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Another curiosity . . .

Another curiosity . . .

From: Ed Stevens <nospam_at_noway.nohow>
Date: Thu, 06 Mar 2003 17:16:09 -0600
Message-ID: <3clf6v0o3p4pg7qgk8507stmrt8kac5utr@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 Thu Mar 06 2003 - 17:16:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US