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

Home -> Community -> Mailing Lists -> Oracle-L -> database_properties not in dictionary

database_properties not in dictionary

From: Sinardy Xing <oracle.rdbms_at_gmail.com>
Date: Fri, 1 Dec 2006 11:55:45 +0800
Message-ID: <f52c14170611301955w3530b50w102c18880a04d26c@mail.gmail.com>


Hi all,

Do you know why database properties not listed in the dictionary?

SQL> select owner, object_type from dba_objects where object_name like
'%DATABASE_PROPERTIES%';

OWNER                          OBJECT_TYPE
------------------------------ -------------------
SYS                            VIEW
PUBLIC                         SYNONYM

SQL> select * from dict where table_name like '%DATABASE_PROPERTIES%';

no rows selected

SQL> c/dict/dictionary
  1* select * from dictionary where table_name like '%DATABASE_PROPERTIES%' SQL> / no rows selected

SQL> select owner, object_type from dba_objects where object_name like
'%DATABASE_PROPERTIES%';

OWNER                          OBJECT_TYPE
------------------------------ -------------------
SYS                            VIEW
PUBLIC                         SYNONYM

SQL> select * from dict where table_name like '%DATABASE_PROPERTIES%';

no rows selected

-- 
regards,

Sinardy

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 30 2006 - 21:55:45 CST

Original text of this message

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