== Lister tous les schémas  ==
<code TSQL>
set lines 500
select distinct owner, tablespace_name from dba_segments
order by owner;
</code>


== Lister tous les schémas non System ==
<code TSQL>
set lines 500
select distinct owner, tablespace_name from dba_segments
where tablespace_name not in ('SYSAUX','SYSTEM')
and owner not in ('SYS')
order by owner;
</code>