mag@mutation_mutation > select tablespace_name from user_tables where table_name='EMP';

TABLESPACE_NAME
------------------------------
SYSTEM

mag@mutation_mutation > select table_name from dba_tables where tablespace_name='USERS';

TABLE_NAME
------------------------------
A
S
E
TEST23
TEST11
REPOSITORY
DUM_DEPT
B
H
I
PLAN_TABLE
EMP
DEPT
SALGRADE
BONUS
ANOTHER_DEPT
T1
T2
TEST
EMP
DEPT
BONUS
SALGRADE

23 rows selected.