-- #############################################################################################
--
-- %Purpose: Show Views for Schmea-Owner
--
-- #############################################################################################
--
spool show_views.lst
ttitle left 'All Database Views' skip 2
set feed off
set pagesize 30000
set linesize 200
break on owner skip 1
column owner format A5 heading 'View|Owner'
column view_name format A20 heading 'View|Name'
column text_length format 9999999 heading 'View-Length|[Bytes]'

select  substr(owner,1,5) owner,
      substr(view_name,1,60) view_name,
      text_length
from dba_views
where owner not in ('SYS','DBSNMP','SYSTEM')
order by 1,2,3;
spool off;
