Check Default Tablespaces

Check default tablespaces of the database:

select * 
from   database_properties
where  property_name like '%TABLESPACE'
order by property_name
;

And the users:

select username
,      default_tablespace
,      temporary_tablespace
from   dba_users
order by username
;