File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 29249
    
139

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: 3436
    
  47

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
Oracle JMS's AQjmsQueueConnectionFactory on Oracle Standard Edition
license for Advanced security options
How to find out that the DB installed has partition feature enabled or not?
Why EJB injection is not available on J2SE?
Why EJB injection is not available on J2SE?