How to determine the Edition for Oracle 9i

From: <>
Date: Wed, 6 Aug 2008 11:29:55 -0700 (PDT)
Message-ID: <>

Hi All--

I have a machine running 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 - Production
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production NLSRTL Version - 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. Received on Wed Aug 06 2008 - 13:29:55 CDT

Original text of this message