Re: schemas

From: <ddf_dba_at_my-deja.com>
Date: 2000/06/23
Message-ID: <8j0hl0$j3h$1@nnrp1.deja.com>#1/1

In article <8j03ia$ag2$1_at_phunn2.um.us.sbphrd.com>, "Sougato Das" <sougato_das_at_hotmail.com> wrote:
> Does anyone know what query would return the names of all the schemas
in the
> database instance I'm currently logged into?
> Oracle v.7.3.3.6.0
>
> thanks,
> Sougato
>
>

select distinct owner
from all_tables;

This should report every user account that has created an object in the instance.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Jun 23 2000 - 00:00:00 CDT