select TABLE_OWNER, TABLE_NAME, COLUMN_NAMEfrom dba_ind_columns tblwhere tbl.table_name like '%MY_TBL%'