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';