To know tablespaces of oracle user

To know the tablespace assigned to a user run following query on sqlplus

select  USERNAME,
 CREATED,
 PROFILE,
 DEFAULT_TABLESPACE,
 TEMPORARY_TABLESPACE
from  dba_users
order  by USERNAME

Sphere: Related Content