Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is there anyway to Validate a entire Schema........

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

From: Scott Weinrich <SWEINRICH_at_FNIS.COM>
Date: 24 Feb 2004 11:29:31 -0800
Message-ID: <beac86c3.0402241129.710cc75f@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 Received on Tue Feb 24 2004 - 13:29:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US