How can I determine if the Edition of Oracle 8.0.5 that is iinstalled is Standard or Enterprise?
Thanks,
Printable View
How can I determine if the Edition of Oracle 8.0.5 that is iinstalled is Standard or Enterprise?
Thanks,
Login thru Sql plus and check the the first few lines before the prompt. It might say it there.
system@dev815nt.us> select * from v$version
2 /
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.5.1.0 - Production
PL/SQL Release 8.1.5.1.0 - Production
CORE Version 8.1.5.0.0 - Production
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production
Version 8.0.5 doesn't announce what edition it is in SQL*Plus.
I also tried v$version and doesn't say either.
I guess, if it doesn't say explicitly as "Enterprise Edition", its standard edition.
If its an Enterprose Edition, you would see output similar to the one listed by Jeff, else without the "Enterprise Edition " on the first line.