REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	c_tab_val.sql
REM
REM <SQLDIR_GRP>TAB INDX MAINT</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (www.dbatoolz.com)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	validate structure cascade for tables
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	c_tab_val.sql
REM 
REM Example:
REM	c_tab_val.sql
REM
REM
REM History:
REM	08-28-1998	VMOGILEV	Created
REM
REM

set term on

accept owner_name char prompt "Enter Schema Name [Enter For All]:"
prompt 
prompt Generating dynamic SQL to analyze tables
prompt This will take some time on large databases
prompt 

set term on
SET PAGESIZE 0
set feedback off



select 'analyze table '||owner||'.'||table_name||' validate structure cascade;'
from
dba_tables
where owner like nvl(upper('&OWNER_NAME'),'%')

SPOOL tab_val.tmp

prompt spool tab_val.out
prompt set term on
prompt prompt
prompt prompt Running SQL to validate tables
prompt prompt This will take some time on large databases
prompt prompt 
prompt set term off 
/
prompt spool off
prompt set term on
prompt set feedback on
prompt prompt =========================================
prompt prompt Please Review the output file tab_val.out
prompt prompt For validation errors !!!!!!
prompt prompt ========================================

SPOOL OFF


@tab_val.tmp