Re: dbms package? - analyze table validate structure

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

Other related posts: