How to determine the Edition for Oracle 9i
Date: Wed, 6 Aug 2008 11:29:55 -0700 (PDT)
I have a machine running 188.8.131.52.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 184.108.40.206.0 - Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for 32-bit Windows: Version 22.214.171.124.0 - Production NLSRTL Version 126.96.36.199.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