How can I view schema?

The MMC is used to view the schema master not dll file but you need to register theschmmgmt.dll before you can use the mmctype regsvr32 schmmgmt.dll

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.

Normal View.

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...

views are the way in which different people see things