The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.
create table user_views_clob (view_name VARCHAR2(32), clob_text CLOB) / insert into user_views_clob select view_name, to_lob(text) from user_views / and do the search like select * from...