SQL Stuff

select 
    ut.table_name, ut.tablespace_name
from 
    user_tab_columns utc,
    user_tables ut
where 
    utc.table_name = ut.table_name and
    utc.column_name = upper('&colname') and
    ut.tablespace_name = upper('&tsname')