SET HEAD OFF
SPOOL VALIDATE.TXT
SELECT 'ANALYZE TABLE '||'&&OWNER'||'.'||OBJECT_NAME||' VALIDATE STRUCTURE CASCADE;'
 FROM DBA_OBJECTS
 WHERE OWNER ='&&OWNER'
 AND OBJECT_TYPE = 'TABLE'
/
SPOOL OFF
SET HEAD ON
@VALIDATE.TXT