set pages 1000 lines 132 trimspool on;

select tablespace_name, contents, status from dba_tablespaces;

select 'alter user ' || username || ' default tablespace XXX temporary tablespace TEMP;'
from dba_users 
where default_tablespace = 'SYSTEM' or temporary_tablespace = 'SYSTEM';