Re: Re : Which Oracle Edition am I running

OK don't know how it was for 8i but here are records for 10g
SQL> conn ***/***@10enterprise
Connected.
SQL> select * from PRODUCT_COMPONENT_VERSION;

PRODUCT
---------------------------------------------------------------------------
VERSION
---------------------------------------------------------------------------
STATUS
---------------------------------------------------------------------------
NLSRTL
10.2.0.1.0
Production

Oracle Database 10g Enterprise Edition
10.2.0.1.0
Prod

PL/SQL
10.2.0.1.0
Production

TNS for 32-bit Windows:
10.2.0.1.0
Production


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
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

SQL> conn ***/***@10standart
Connected.
SQL> select * from PRODUCT_COMPONENT_VERSION;

PRODUCT
---------------------------------------------------------------------------
VERSION
---------------------------------------------------------------------------
STATUS
---------------------------------------------------------------------------
NLSRTL
10.2.0.1.0
Production

Oracle Database 10g
10.2.0.1.0
Production

PL/SQL
10.2.0.1.0
Production

TNS for 32-bit Windows:
10.2.0.1.0
Production


Elapsed: 00:00:00.03
SQL> select * from v$version;

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

BTW if I remember correctly some months(weeks???) ago there was
similar discussion here.

Gints Plivna
http://www.gplivna.eu

2007/6/28, Neil Overend <neiloverend@xxxxxxxxx>:

We have records that say it is the Standard Edition, but given my
experrience I don't believe them :-)

--
http://www.freelists.org/webpage/oracle-l

Other related posts: