Re: View to check which options are installed?

From: <fitzjarrell_at_cox.net>
Date: 11 May 2005 20:31:54 -0700
Message-ID: <1115868714.964338.104830@o13g2000cwo.googlegroups.com>

NetComrade wrote:
> e.g. would like to know if Oracle Spatial or Oracle Text are
> installed?
>
> Thought it would be a view containing 'feature' or 'option' but
> nothing came up.
>
> -Andrey
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email

column parameter format a35
column value format a12

select parameter, value
from v$option
order by parameter;

You will need to be SYS or a DBA account to access this view.

David Fitzjarrell Received on Wed May 11 2005 - 22:31:54 CDT