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');