Re: Analyze index validate structure
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Jul 2007 08:41:48 +0100
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@xxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
