• 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