Re: Getting list of databases

In article <36819027.4582409_at_192.86.155.100>,   tkyte_at_us.oracle.com wrote:
> 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
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> 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.
>

/var/opt/oracle/oratab (/etc/oratab on some platforms) is exactly such a list.

--
Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 24 1998 - 00:07:12 CST