• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to find out oracle is enterprise edition or standard edition?

 
Gurumurthy Ramamurthy
Ranch Hand
Posts: 273
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Is there any way through java program to find out that whether the installed oracle is enterprise edition or standard edition?
I have only the hostname, portnumber, SID, username, password available with me.

I was trying to connect to the database and through any SQL commands to find out EE or SE?

Thanks,
Guru
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34870
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I haven't tried it but this site has a promising query:

 
Martin Vajsar
Sheriff
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In your other question (which is locked now) you asked how to test whether partitioning is installed; it can be queries from the v$option view:There are more editions than just EE and SE. If you are interested in a specific option, this is probably better way to test it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic