sysuser.sql

rem SYSUSERS.sql
rem
ttitle "USERS WITH DEFAULT TS'S IN SYSTEM - &1"
column username format a22
column default_tablespace format a25
column temporary_tablespace format a30
set pages 60
spool SYSUSERS.lis
select username,
       default_tablespace,
       temporary_tablespace
from dba_users
where (default_tablespace = 'SYSTEM' or temporary_tablespace = 'SYSTEM')
order by username;
spool out