Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting list of databases
A copy of this was sent to cinnibar_at_netcom.com (Jeff Wood)
(if that email address didn't require changing)
On Thu, 24 Dec 1998 00:45:21 GMT, you wrote:
>Is it possible for a user connected to an Oracle database (say,
>with dba privs), to gain a listing of all databases served by this server?
>
>I'm looking for an equivilent command to the Sybase SQL 'sp_helpdb'
>
In Sybase, a "database" in a database is just a logical partion of the same database. If you had >1 Sybase "instance" running with a different set of files, sp_helpdb would only tell you of the one set of databases -- not the databases in the other server on the same machine. Its not another database in Oracle terms.
Oracle Instances have one database -- we reference objects via SCHEMA.OBJECT_NAME. Sybase instances allow for a three node naming scheme database.schema.object_name within a database.
Therefore, if you are connected to an Oracle Instance -- it only knows about itself and not any other instances that may be executing on the same machine.
>Jeff Wood
>jeff_wood_at_vantive.com
>Systems Consultant
>Vantive Corp.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Dec 23 1998 - 18:55:02 CST