Re: Get all schemas

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 9 Nov 2006 07:22:03 -0800
Message-ID: <1163085723.514485.89160@k70g2000cwa.googlegroups.com>

On Nov 9, 5:38 am, Thomas Kellerer <TAAXADSCB..._at_spammotel.com> wrote:
> On 09.11.2006 11:19 igor.mar..._at_gmx.ch wrote:
>
> > Hi all.
>
> > Is there any simple way to get list of all schemas like "select name
> > from ALL_SCHEMA"...SELECT username FROM all_users;
>
> --
> It's not a RootKit - it's a Sony

If you define a schema to be a username that owns objects then instead of reading dba_users you should query dba_objects for the distinct owners.

UT1 > select distinct(owner) from dba_objects;

OWNER

---

DBSNMP
ECO_IRM
OUTLN
PERFSTAT
PUBLIC
SCOTT
SYS
SYSTEM
...

HTH -- Mark D Powell -- Received on Thu Nov 09 2006 - 09:22:03 CST