list all tables.sql

on June 23, 2008 at 12:28 pm
Posted In: Oracle DB Objects (tables, sql etc) (Cat)

— tab_lst.sql
— mdw – very simple tables listing
set pause on pages 24 pause ‘Any Key>’
colu num_rows form 9999,999,999
spool tab_lst.lst
select table_name
      ,owner
      ,num_rows
from  all_tables
where table_name like upper(nvl(‘&Tab_name’,’WHOOPS’)||’%’)
and owner not in (‘SYS’,’SYSTEM’)
/
spool off
clear colu