On Wed, Jul 04, 2007 at 02:49:32PM +0530, dgaikwad wrote:
> Date: Wed, 4 Jul 2007 14:49:32 +0530
> From: dgaikwad <oracledba-ezmlmshield-x12833214.[Email address protected]
> Subject: How to find Oracle Installation Details
> To: LazyDBA Discussion <[Email address protected]
>
> 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?

connect as 'SYS';
select * from v$version;


> ---------------------------------------------------------------------
> 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
>

--
Antuan Avdioukhine (DEKA-RIPE).
Convey Plus Telecommunications
St.Petersburg, Russia.

Oracle LazyDBA home page