database_properties not in dictionary
- From: "Sinardy Xing" <oracle.rdbms@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 1 Dec 2006 11:55:45 +0800
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
Other related posts: