• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
util a/17/15/4 ("Analyze Table/Index" / "Validate Index Structure") gets "specified index does not exist" (even though the table does exist for this library):

Enter Index Name to Validate Structure : z07a
enter yes to Analyze z07a indexes for USM01 yes
analyze index USM01.Z07A validate structure
*
ERROR at line 1:
ORA-01418: specified index does not exist

no rows selected

Yet, util a/17/11/2 shows that the z07a is defined in usm01.

Resolution:
You need to write the name of the Oracle index (z07a_id) -- instead of the table (z07a).
This issue is still open and was escalated to Development for further investigation <2009-02-15 01:00:03>.

• Article last edited: 10/8/2013