Re: dbms package? - analyze table validate structure

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: Jon.Crisler@xxxxxxx
  • Date: Wed, 31 Dec 2008 10:55:47 -0600

  No, I believe 'analyze' is the way to go on this. Just roll it into a
package using EXECUTE IMMEDIATE .


Bradd Piontek
  "Next to doing a good job yourself,
        the greatest joy is in having someone
        else do a first-class job under your
 -- 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.
> --

Other related posts: