SELECT DISTINCT
 owner, table_name
FROM all_tab_columns
WHERE data_type = UPPER('&i_data_type')
;