Re: schemas

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/23
Message-ID: <961787553.27488.0.pluto.d4ee154e@news.demon.nl>#1/1

select distinct owner
from dba_objects
where owner not in ('SYS','SYSTEM')

Hth,

Sybrand Bakker, Oracle DBA

"Sougato Das" <sougato_das_at_hotmail.com> wrote in message news:8j03j4$ag3$1_at_phunn2.um.us.sbphrd.com...
> 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
>
>
Received on Fri Jun 23 2000 - 00:00:00 CDT