dbms_utility is your friend...
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Scott Weinrich" <SWEINRICH_at_FNIS.COM> wrote in message
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?
Received on Wed Feb 25 2004 - 03:11:24 CST
