define APPName="&1"
set heading off;
set verify off;
set newpage 0
set feedback off;
set rtrimspool on;
set termout off;
set pagesize 40000;
set lines 220;
col db_name form a15;
col app_id form a20;
set colsep ',';
col OWNER form a25;
col TABLE_NAME form a35;
COLUMN DB_NAME NEW_VALUE _DB_NAME NOPRINT
SELECT rtrim(NAME) DB_NAME  FROM v$database;
COLUMN DB_NAME PRINT
spool &APPNAME._&_DB_NAME._html_table_stats_rpt.csv
select rtrim(sysdate) report_date,
(select rtrim('&APPName') from dual) App_name,
(select rtrim('&_DB_NAME') from dual) db_name,
rtrim(owner),
rtrim(table_name), 
rtrim(last_analyzed),
rtrim(NUM_ROWS)
from dba_tables 
where owner not in('MGMT_VIEW',
'SYS',
'SYSTEM',
'DBSNMP',
'SYSMAN',
'OUTLN',
'MDSYS',
'ORDSYS',
'EXFSYS',
'DMSYS',
'WMSYS',
'CTXSYS',
'ANONYMOUS',
'XDB',
'ORDPLUGIN',
'SI_INFORM',
'N_SCHEMA',
'OLAPSYS',
'TSMSYS',
'BI',
'PM',
'MDDATA',
'IX',
'SH',
'DIP',
'OE',
'HR',
'PERFSTAT')
and last_analyzed < add_months(sysdate,-1) 
order by last_analyzed,owner;

29-Jul-11	APP00111_1                      	FASTREPE       	REP2_BACKUP                   	FR_UNEXCEPTED_ERRORS          	15-Nov-09	0
29-Jul-11	APP00111_1                      	FASTREPE       	REP2_BACKUP                   	AUDIT_DDL                     	15-Nov-09	0
29-Jul-11	APP00111_1                      	FASTREPE       	CDMC_ADMIN                    	CDMCDATA                      	15-Nov-09	8448042
29-Jul-11	APP00111_1                      	FASTREPE       	CDMC_ADMIN                    	CDMC_LOG                      	15-Nov-09	0
29-Jul-11	APP00111_1                      	FASTREPE       	CDMC_ADMIN                    	CDMC_DEBUG                    	15-Nov-09	0