Searching with a particular word in view defination
Searching with a particular word in view defination create table dba_views_with_clob as (select owner,view_name,to_lob(text) text from dba_views); select * from dba_views_with_clob where upper(text) like '%TBLCDR%' and owner not like 'REPORT';