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

    Bib z35_id3 Oracle index can not be built, because of duplicates.

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

    Description:
    In copying tables from Prod to Test, we found that the abc01 z35_id3 Oracle index can not be built, because of duplicates

    Resolution:
    The bib z35 is of no use any more. This is described in KB's 5872 and 8192-2055. But you may need to have it to avoid getting errors in the logs.

    You can do one of two things:

    1. util a/17/1 for the abc01 z35 to drop and recreate an empty table. The z35_id3 was built successfully as part of this and now exists. (Note: The abc50 z35 is needed for circ statistics; be sure not to delete that.)

    2. do util a/17/18 for the z35_id3 to delete the duplicates and build a unique z35_id3

    • Article last edited: 10/8/2013