check de la structure de la database

set pagesize 0 
spool analyze1.sql 
select 'prompt ' table_name,'analyze table "' table_name'" validate structure cascade ;' from user_tables;                                 
spool off                                                              
spool analyze1.txt
@analyze1 
spool off
                                                   
set head off feedback off pagesize 500 echo off                        
spool analyze2.sql          
select 'ANALYZE TABLE "'table_name'" VALIDATE STRUCTURE CASCADE;'      
from dba_tables where tablespace_name='SYSTEM';                        
select 'ANALYZE CLUSTER "'cluster_name'" VALIDATE STRUCTURE CASCADE;'  
from dba_clusters where tablespace_name='SYSTEM'; 
spool off 
spool analyze2.txt
@analyze2 
spool off