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

    p_manage_02: drop z01_id1 ... index does not exist

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    I ran p_manage_02 on xxx10. The log file "xxx10_p_manage_02.log" has an error:.
    SQL-ALEPH_ADMIN> drop index xxx10.z02_id1.
    ERROR at line 1:.
    ORA-01418: specified index does not exist..
    But now that the job is done, UTIL-A-17-14 shows that the z01_id1 exists and is valid. What should be done to fix this?

    Resolution:
    There are different scenarios where a job could be trying to drop an index which (correctly) does not exist. (For instance, if a preceding run failed or was canceled.).
    As long as it ends up OK, you don't need to worry about it..
    If the message occurs in trying to *create* an index, that usually indicates a problem.

    • Article last edited: 10/8/2013