Re: Database names?

From: daniel clamage <dclamage_at_earthlink.net>
Date: Sun, 23 Feb 2003 01:34:36 GMT
Message-ID: <MyV5a.1102$cD5.116608@newsread2.prod.itd.earthlink.net>

You probably are asking how to get the names of all the schema names that are on a particular instance. Log in as SYS or SYSTEM and run this query: SELECT username
FROM dba_users;

This will list all the schemas that exist on that instance. When you install the 9i starter database, you get a bunch of schemas:

           USERNAME

---

SYS
SYSTEM
DBSNMP
SQLNAV
SCOTT
OUTLN
WMSYS
ORDSYS
ORDPLUGINS
MDSYS
CTXSYS
QS_ES
QS_WS
QS
QS_ADM
SH
PM
OE
HR
RMAN

QS_CS
QS_CB
QS_CBADM
QS_OS

XDB
ANONYMOUS
WKSYS
WKPROXY
ODM
ODM_MTR
OLAPSYS 30 row(s) retrieved Received on Sat Feb 22 2003 - 19:34:36 CST