Re: Analyze index validate structure

Analyze index validate structure

    checks the index for self-consistency

analyze table xxx validate structure cascade;

    checks that the table is valid and consistent     with all its indexes. i.e. if a row exists it is     indexed and if an index entry exists there is     a matching row.

This checks every index, and remember that it locks the table

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

>
> Subject: Analyze index validate structure
> Date: Mon, 9 Jul 2007 17:01:06 -0400
> From: "Schauss, Peter" <peter.schauss_at_ngc.com>
>
> I am still trying to track down the source of an intermittent Ora-01410
> error. If the above command returns no errors does this assure me that
> all of the leaves on the index point to valid rows in the target table?
>
> (Oracle 8.1.7.4 on SunOS 5.9).
>
> Thanks,
> Peter Schauss
>

--
http://www.freelists.org/webpage/oracle-l