Jon, No, I believe 'analyze' is the way to go on this. Just roll it into a package using EXECUTE IMMEDIATE . HTH Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class job under your direction." -- William Feather On Wed, Dec 31, 2008 at 10: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. > > Thanks in advance. > -- > //www.freelists.org/webpage/oracle-l > > >