Re: schemas

From: Bob Fazio <rfazio_at_home.com.nospam>
Date: 2000/06/23
Message-ID: <lNR45.16891$A%3.189665@news1.rdc2.pa.home.com>#1/1

Sybrand's query is most likely what you want, but all users have the potential, if granted the appropriate rights, to create objects/tables.

If you only consider tables/indexes as schema's then query dba_tables. If you consider procedures as schema's too, even if they have no tables of their own, use Sybrand's query. If you are just interested in all created users use dba_users.

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:961787553.27488.0.pluto.d4ee154e_at_news.demon.nl...


> 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