How to list tables which are under TABLESPACE

select owner, table_name,tablespace_name

   from dba_tables

  where tablespace_name='DEV_OIM';

( or )

select table_name ,tablespace_name 

from user_tables

where tablespace_name='YOUR TABLE SPACE NAME';