On Wed, Dec 31, 2008 at 8:37 AM, Crisler, Jon <Jon.Crisler@xxxxxxx> wrote: > 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. > Hi Jon, Have you investigated why indexes are being corrupted? I would think that to be a rather unusual circumstance. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist