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

SAP Backdoors {placeholder Post]

Fiori Apps Keep Calling Internal Hostname / Internal FQDN