Re: How to determine the Edition for Oracle 9i

From: <fitzjarrell_at_cox.net>
Date: Wed, 6 Aug 2008 12:23:10 -0700 (PDT)
Message-ID: <b996c64e-82c1-4550-a4d3-5ec3ecc6f62c@l64g2000hse.googlegroups.com>

On Aug 6, 1:29 pm, jeff..._at_yahoo.com wrote:
> Hi All--
>
> I have a machine running 9.2.0.6.0 on Windows 2003.  I would like to
> confirm whether it is Standard or Enterprise Edition that is
> installed.  I have tried
>
> select banner from v$version
>
> The output is:
>
> Oracle9i Release 9.2.0.6.0 - Production
> PL/SQL Release 9.2.0.6.0 - Production
> CORE    9.2.0.6.0       Production
> TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
> NLSRTL Version 9.2.0.6.0 - Production
>
> I've also tried
>
> select product, version from product_component_version;
>
> but it does not indicate Standard or Enterprise.
>
> If anyone knows how to determine the edition that is running that
> would be great.
>
> thank you.

You're running Standard. Enterprise would be explicitly listed:

SQL> select banner
  2 from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production

David Fitzjarrell Received on Wed Aug 06 2008 - 14:23:10 CDT