column temporary_tablespace format a20
column default_tablespace   format a20

select username, created, default_tablespace, temporary_tablespace, account_status
  from dba_users
 order by account_status, created
/