CONSULTAR TODAS LAS TABLAS QUE CONTIENEN UN NOMBRE

Select owner, table_name
from all_tables
where table_name like upper('%SURVEY%')
order by owner, table_name;