select distinct tablespace_name from dba_tables where owner='HR' select distinct tablespace_name from dba_indexes where owner='HR'