Lister tous les schémas
set lines 500
select distinct owner, tablespace_name from dba_segments
order by owner;
Lister tous les schémas non System
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;