Re: Re : Which Oracle Edition am I running

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 28 Jun 2007 16:33:11 +0300
Message-ID: <6e49b6d00706280633ud30a6e2la579b1cfde9366bb@mail.gmail.com>

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_at_gmail.com>:
> 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

Received on Thu Jun 28 2007 - 08:33:11 CDT