Re: Oracle 10g - price and expiration?

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 22 Aug 2006 16:25:04 -0700
Message-ID: <1156289103.191138@bubbleator.drizzle.com>

Andy Hassall wrote:

> On 22 Aug 2006 15:57:55 -0700, joe1977_at_tlen.pl wrote:
>

>> I am trying to check my Oracle version (since it is already there on
>> two processors) - this is what I got:
>>
>> BANNER
>> ----------------------------------------------------------------
>> Oracle Database 10g Release 10.2.0.1.0 - Production
>> PL/SQL Release 10.2.0.1.0 - Production
>> CORE 10.2.0.1.0 Production
>> TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
>> NLSRTL Version 10.2.0.1.0 - Production
>>
>> 5 rows selected.
>>
>> I cannot see which type of 10g was installed up there.

> 
>  That's Oracle Standard Edition.
> 
>  Enterprise Edition and Express Edition both show as extra text in the versions
> in v$version.

For example:
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Aug 22 16:21:46 2006

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> SELECT * FROM v$version;

BANNER

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production NLSRTL Version 10.2.0.2.0 - Production

SQL> Also check out the following query for additional information: set linesize 121
col comp_name format a40

SELECT comp_name, version, status
FROM dba_registry;

Maybe I can regain some small amont of face after that read<>write misinterpretation. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Aug 22 2006 - 18:25:04 CDT