AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Oracle Databases' list          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Kyuu Guest Posted: Tue Dec 09, 2003 4:49 pm    Post subject: Oracle Databases' list I would like to get the list of databases existing on my Oracle server. Does anyone know how to do that ? Thank you. Back to top Thomas Kellerer Guest Posted: Wed Dec 10, 2003 8:04 am    Post subject: Re: Oracle Databases' list Kyuu schrieb: Quote: I would like to get the list of databases existing on my Oracle server. Does anyone know how to do that ? Thank you. What do you mean with "Database". This concept does not really exist in Oracle. Do you mean instances? Then you are out of luck, as I think there is no way of finding out. If you mean schemas (=users), then you can query DatabaseMetaData for them as already suggested Thomas Back to top Kyuu Guest Posted: Wed Dec 10, 2003 10:43 am    Post subject: Re: Oracle Databases' list [email]usenet.user (AT) email (DOT) it[/email] (gnazio) wrote in message news:<fef6c85a.0312091547.78d32fa9 (AT) posting (DOT) google.com>... Quote: soulfi (AT) wanadoo (DOT) fr (Kyuu) wrote in message news:<e9a8067d.0312090849.4e385f9f (AT) posting (DOT) google.com>... I would like to get the list of databases existing on my Oracle server. Does anyone know how to do that ? Thank you. Take a look at java.sql.DatabaseMetaData Thanks for the advise, but the function getDatabaseMetaData is only accessible when we are connected to a database. But I don't know the name of the database, so i can't connect. I want to get the list of databases on the oracle server, and then choose a database between all of them, in order to connect to it. Thanks. Back to top Kyuu Guest Posted: Wed Dec 10, 2003 1:56 pm    Post subject: Re: Oracle Databases' list [email]usenet.user (AT) email (DOT) it[/email] (gnazio) wrote in message news:<fef6c85a.0312091547.78d32fa9 (AT) posting (DOT) google.com>... Quote: soulfi (AT) wanadoo (DOT) fr (Kyuu) wrote in message news:<e9a8067d.0312090849.4e385f9f (AT) posting (DOT) google.com>... I would like to get the list of databases existing on my Oracle server. Does anyone know how to do that ? Thank you. Take a look at java.sql.DatabaseMetaData Thanks for the advise but the function getDatabaseMetaData is only accessible when you are connected to a specific database on Oracle. But i don't have any database's name. I want to find the list of databases on the oracle server in order to connect to one of them. Thanks. Back to top Thomas Kellerer Guest Posted: Wed Dec 10, 2003 3:16 pm    Post subject: Re: Oracle Databases' list Kyuu schrieb: Quote: I would like to get the list of databases existing on my Oracle server. Does anyone know how to do that ? Thank you. Take a look at java.sql.DatabaseMetaData Thanks for the advise but the function getDatabaseMetaData is only accessible when you are connected to a specific database on Oracle. But i don't have any database's name. I want to find the list of databases on the oracle server in order to connect to one of them. Thanks. You want to get the list *before* connecting. That's impossible! And (as I said in my other post) Oracle does not have "databases" Regards Thomas Back to top Bjorn Abelli Guest Posted: Wed Dec 10, 2003 5:53 pm    Post subject: Re: Oracle Databases' list "Thomas Kellerer" wrote... Quote: Kyuu schrieb: Thanks for the advise but the function getDatabaseMetaData is only accessible when you are connected to a specific database on Oracle. But i don't have any database's name. I want to find the list of databases on the oracle server in order to connect to one of them. You want to get the list *before* connecting. That's impossible! Not impossible. He just have to ask his DBA for the list... ;-) Quote: And (as I said in my other post) Oracle does not have "databases" Well, this misconception is understandable as Oracle themselves in some of their documentation sometimes uses "database" as synonym to "database instances"... // Bjorn A Back to top Kyuu Guest Posted: Thu Dec 11, 2003 10:15 am    Post subject: Re: Oracle Databases' list Ok thanks. Since it seems impossible, I will just force the users to enter the name of the instances. I wanted to show them the lists of instances, but ... It's not a big deal. Thank you. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.