my dog learned polymorphism*
The moose likes JDBC and the fly likes How to find out oracle is enterprise edition or standard edition? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to find out oracle is enterprise edition or standard edition?" Watch "How to find out oracle is enterprise edition or standard edition?" New topic
Author

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

Gurumurthy Ramamurthy
Ranch Hand

Joined: Feb 13, 2003
Posts: 272
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

Joined: May 26, 2003
Posts: 30596
    
154

I haven't tried it but this site has a promising query:



[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

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.
 
GeeCON Prague 2014
 
subject: How to find out oracle is enterprise edition or standard edition?