Difference between v$option and dba_registry views ??
569701May 16 2007 — edited May 16 2007Hello all,
Whats the difference between v$option and dba_registry views.
SQL> select * from v$option ;
PARAMETER VALUE
---------------------------------------------------------------- ----------
Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
Bit-mapped indexes TRUE
.
.
.
.
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
Proxy authentication/authorization TRUE
..
...etc
47 rows selected
and
SQL> select comp_name from dba_registry;
Oracle9i Catalog Views
Oracle9i Packages and Types
2 rows selected.
Why the difference ??
TIA,
Jj
Message was edited by:
user566698
the DB is 9.2.0.7