How to determine the Edition for Oracle 9i
From: <jeffbam_at_yahoo.com>
Date: Wed, 6 Aug 2008 11:29:55 -0700 (PDT)
Message-ID: <25446bca-92b5-4efd-aaaa-c35a9983eb51@79g2000hsk.googlegroups.com>
Date: Wed, 6 Aug 2008 11:29:55 -0700 (PDT)
Message-ID: <25446bca-92b5-4efd-aaaa-c35a9983eb51@79g2000hsk.googlegroups.com>
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. Received on Wed Aug 06 2008 - 13:29:55 CDT