Finding Searching Table name or Column name in Oracle

Try:

select table_name from user_tables where table_name like '%myString%';

select * from all_tab_columns where COLUMN_NAME like '%myString%'

Thanks...