Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is there anyway to Validate a entire Schema........
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