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: <sekrafi.m_at_gmail.com>
Date: Thu, 14 Jun 2007 03:55:07 -0700
Message-ID: <1181818507.137178.69660@q19g2000prn.googlegroups.com>


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 Received on Thu Jun 14 2007 - 05:55:07 CDT

Original text of this message

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