Re: Oracle version

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 04 May 2004 09:38:33 -0700
Message-ID: <1083688711.876994@yasure>

Howard J. Rogers wrote:

> gigione wrote:
>

>> Hello everybody.
>> Is there an SQL command telling me if there is installed Standard or
>> Enterprise version of Oracle 9.2 installed on a windows 2000 server?
>>
>> If there isn't, how can I know it? Where must I look for?
>> I found the key ORACLE_BUNDLE_NAME  in the registry, but I don't know if
>> this is correct.
>>
>> thank's a lot.
>>
>> Sam.
>>
>>

>
> select * from v$version;
> BANNER
> ---------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.1.0
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - P
> NLSRTL Version 9.2.0.1.0 - Production
>
> ...where the first line of the BANNER says it all.
>
> Somewhat more subtly, try:
>
> SQL> select * from v$option
> 2 where parameter = 'Partitioning';
>
> PARAMETER
> -------------------------------------------
> VALUE
> -------------------------------------------
> Partitioning
> TRUE
>
> ...which, being an Enterprise Edition only feature, could only be TRUE
> if you've got the Enterprise Edition.
>
> Regards
> HJR
>

Gee Howard ... shouldn't you patch that thing to at least 9.2.0.4? ;-)

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Tue May 04 2004 - 11:38:33 CDT