Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    util a/17/15/4 gets "specified index does not exist" (even though it does)

    • 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