select
segment_name,
partition_name,
tablespace_name
from
user_segments
where
segment_name=‘TABLE_NAME’;