Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: récuperer la liste des bases de données Oracle:::

Re: récuperer la liste des bases de données Oracle:::

From: <matthias.hoys_at_gmail.com>
Date: Thu, 14 Jun 2007 04:01:22 -0700
Message-ID: <1181818882.283264.295100@i13g2000prf.googlegroups.com>


On Jun 14, 12:55 pm, sekraf..._at_gmail.com wrote:
> On 14 juin, 11:01, herta <herta.vandeney..._at_gmail.com> wrote:
>
>
>
>
>
> > On Jun 14, 10:18 am, sekraf..._at_gmail.com wrote:
>
> > > Je cherche à ecuperer la liste des bases de données existantes sur un
> > > serveur Oracle.
> > > C'est certainement en interrogeant les vues systèmes;
>
> > > Mais j'arrive pas à voir la solution.
>
> > > Alors merci pour vos aides.
> > > Merci
> > > Mustapha
>
> > If it has not been tampered with, you could look at oratab (usually
> > in /etc/ or in var/opt/oracle/). The first column in the list should
> > give you the names of all the database on the system.
>
> > Assuming you are on linux or unix, you can see which databases are
> > active by running a command such as 'ps auxw | grep smon'. The string
> > following 'ora_smon_' are your database instance names.
>
> > Kind regards,
>
> > Herta
>
> i'm on Windows,
> Oracle 9i,
>
> What I mean with listing databases, is all databases on server, active
> and not active.
>
> I.E the equivalent of MS SQL Server:
> SELECT name FROM master..sysdatabases;
>
> THX- Hide quoted text -
>
> - Show quoted text -

I think you are confusing SQL Server "databases" with Oracle "schemas". A schema is all objects belonging to a specific Oracle user.
Maybe you should check out the Oracle concepts guide in the documentation.

Matthias Received on Thu Jun 14 2007 - 06:01:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US