ORACLE - View user (schema) and its corresponding tablespace

column username format A12 word_wrapped

column default_tablespace format A20 word_wrapped

column temporary_tablespace format A20 word_wrapped

column created heading format A12

select username ,default_tablespace ,temporary_tablespace ,created from dba_users

where username like '{USERNAME}%';