Re: Which Oracle Edition am I running

  • From: "Neil Overend" <neiloverend@xxxxxxxxx>
  • To: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
  • Date: Thu, 28 Jun 2007 20:45:44 +0100

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

select * from v$version;


Other related posts: