Standard Edition vs Enterprise Edition ??

[mvander]

How can I determine if the Edition of Oracle 8.0.5 that is iinstalled is Standard or Enterprise?
Thanks,

[Halo]

Login thru Sql plus and check the the first few lines before the prompt. It might say it there.

[marist89]

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

[mvander]

Version 8.0.5 doesn't announce what edition it is in SQL*Plus.
I also tried v$version and doesn't say either.

[gsprince]

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.