select table_name, tablespace_name, status from user_tables
または、
select table_name, tablespace_name, status from tabs
http://www.shift-the-oracle.com/view/data-dictionary-view/table-index-view-list.html