*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30136
    
150

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: 3606
    
  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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to find out oracle is enterprise edition or standard edition?
 
Similar Threads
license for Advanced security options
Why EJB injection is not available on J2SE?
Oracle JMS's AQjmsQueueConnectionFactory on Oracle Standard Edition
Why EJB injection is not available on J2SE?
How to find out that the DB installed has partition feature enabled or not?