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 -> database_properties is not a database dictionary view?

database_properties is not a database dictionary view?

From: charlie cs <cs3526(no-spam)_at_yahoo.com>
Date: Fri, 11 Apr 2003 11:20:56 GMT
Message-ID: <syxla.8520$d8.3019@nwrdny02.gnilink.net>


We are using 9.2.0.2.0 on solaris.

When I select from dict

SQL> select table_name from dict where
upper(table_name)='DATABASE_PROPERTIES';

no rows selected

but the view is clearly there

SQL> select count(*) from database_properties;

  COUNT(*)


        25

Is this a bug or what?

Thanks Received on Fri Apr 11 2003 - 06:20:56 CDT

Original text of this message

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