Question:

> How do I check, if an oracle 8.0.5 is standard edition or enterprise
> edition?

Answer:

By looking at the banner appearing during sign-on
or select * from v$version after sign-on

My guess would be Oracle x.y.z. production is standard.
You could also query v$option. In the enterprise edition all options should be enabled, the standard edition is lacking options.
 

Hth,

Sybrand Bakker, Oracle DBA

Sample:

tunix $ sqlplus system

SQL*Plus: Release 8.0.5.0.0 - Production on Mi Mär 1 12:51:26 2000
Oracle8 Release 8.0.5.0.0 - Production
...
SQL> select * from v$version ;
----------------------------------------------------------------
Oracle8 Release 8.0.5.0.0 - Production