Re: Is there anyway to Validate a entire Schema........

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Tue, 24 Feb 2004 15:12:59 -0500
Message-ID: <EfO_b.8191$253.730626@news20.bellglobal.com>

"Scott Weinrich" <SWEINRICH_at_FNIS.COM> a écrit dans le message de news:beac86c3.0402241129.710cc75f_at_posting.google.com...
> I was curious if there is command/tool to validate an entire schema,
> similar to the way you can gather schema stats using
> DBMS_STATS.GATHER_SCHEMA_STATS, or do you have to loop through the
> schema using ANALYZE TABLE tablename VALIDATE STRUCTURE CASCADE?
>
> Thanks
>
> Scott

Why not just write a little script ?

set head off
spool valid_schema.sql
select 'analyze table '||owner||'.'||table_name||' validate structure cascade;'
from dba_tables
where owner = upper('&your_owner')
/
spool off
@valid_schema

I figure you get the idea Received on Tue Feb 24 2004 - 14:12:59 CST