Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Which Oracle Edition am I running

Re: Which Oracle Edition am I running

From: Neil Overend <neiloverend_at_gmail.com>
Date: Thu, 28 Jun 2007 20:45:44 +0100
Message-ID: <5acbeade0706281245w78a8c581j7234718b637d61f2@mail.gmail.com>


Just to clarify, the database that I wanted to check if it was Enterprise or Standard is dead, the disk array ate all the data files, so I can't run any SQL. All I had was the ORACLE_HOME directory. I recovered the database to a different server, from backups, which I know had Standard Edition because I installed it this morning.

>
> The best way to check is to query v$version. The banners are not always
> reliable.
>
> select * from v$version;
>
> Pat

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 28 2007 - 14:45:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US