Or try to
select * from v$version;
as sys or system to get the "running" Oracle database server version;

/karl

OUTPUT :

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production

-----Ursprüngliche Nachricht-----
Von: dgaikwad [mailto:oracledba-ezmlmshield-x12833214.[Email address protected]
Gesendet: Mittwoch, 4. Juli 2007 11:20
An: LazyDBA Discussion
Betreff: How to find Oracle Installation Details

Hi DBA's

How to know which type of Oracle Server Software Installtion is done?

I mean is it is Enterprise or some other type?


Thanks & Regards,
Dinesh G.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html



----------------
Vorsitzender des Aufsichtsrats: Hans-Georg Härter
Geschäftsführung: Egon Behle (Vorsitz), Rolf Bulander, Wolfgang Runge, Karl-Heinz Schrödl, Wolfgang Zeitz
Sitz: Schwäbisch Gmünd - Handelsregistereintrag: Amtsgericht Ulm HRB 701678

Oracle LazyDBA home page