Re: Re : Which Oracle Edition am I running
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: neiloverend@xxxxxxxxx
- Date: Thu, 28 Jun 2007 16:33:11 +0300
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 :-)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
