Re: schemas

In article <8j0hl0$j3h$1_at_nnrp1.deja.com>,   ddf_dba_at_my-deja.com wrote:
> 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.
>

The query SHOULD read:

select distinct owner
from all_objects;

This will include owners of procedures, views packages, functions and indexes as well and will not be restricted to just tables.

--
David Fitzjarrell
Oracle Certified DBA


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