dbms package? - analyze table validate structure

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 31 Dec 2008 11:37:29 -0500

Does anybody know if there is an equivalent Oracle provided package like
DBMS_STATS that does the same thing as "analyze table (name) validate
structure" ?  I have a system that seems to encounter corrupted indexes
now and then, am I want to implement a preventative process via dbms_job
to check all the tables and indexes in a particular schema.

Thanks in advance.
--
//www.freelists.org/webpage/oracle-l


Other related posts: