Based on @Roobie's solution, the code below searches in all schemas you have access to, in case the table is not in your own schema. Also added case-insensitive matching.
SELECT owner, table_name FROM all_tab_columns WHERE UPPER(column_name) = UPPER('MYCOL');