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

    util a/17/18: Oracle index changes from UNIQUE to NONUNIQUE

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

    Description:
    After running util a/17/18 ("Search for Duplicate Keys") you find that the Oracle index -- which had been UNIQUE-- has changed to NONUNIQUE.

    Resolution:
    util a/17/18 always first builds a non-unique index. The above can happen if, when it gives you the choice of "LIST/DELETE", you choose "LIST". In this case, the duplicates are not deleted and the non-unique index remains.

    Though may want to do a run in which you choose "LIST" in order to see the duplicates, this *must* be followed by one of following:

    1. a second run of util a/1718 in which you specify "DELETE"; or

    2. if there are no duplicates, util a/17/3 to rebuild the Oracle index in question.

    • Article last edited: 10/8/2013