Oracle: View all available Schema

Ripped from: http://www.dba-oracle.com/t_display_all_schemas.htm

select distinct
   owner
from
   dba_segments

where
   owner not in (

'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP');

Comments

Popular posts from this blog

Check SecStore KeyPhrase of Java Stack

Windows 2003 W2k3 Getting Current MTU Size

Python: thread.error: can't start new thread