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');
select distinct
owner
from
dba_segments
where
owner not in (
'SYSTEM', 'XDB', 'SYS', 'TSMSYS', 'MDSYS', 'EXFSYS', 'WMSYS', 'ORDSYS', 'OUTLN', 'DBSNMP');
Comments
Post a Comment