count.sql

SET ECHO OFF
SET HEADING OFF
SET LINESIZE 200
SET PAGESIZE 0
SET FEEDBACK OFF
SET SPACE 0
SET NEWPAGE 0
SET TRIMSPOOL ON
select unique table_name, sample_size from user_tab_columns where table_name not like 'V_%' 
order by table_name;