How to find out oracle is enterprise edition or standard edition?
Joined: Feb 13, 2003
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?
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.
subject: How to find out oracle is enterprise edition or standard edition?