Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> database_properties not in dictionary
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-lReceived on Thu Nov 30 2006 - 21:55:45 CST
![]() |
![]() |