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

    How to repair indexes without running keyword index regen

    • Article Type: General
    • Product: Voyager
    • Product Version: 7

    Desired Outcome Goal:
    Fix Voyager (non-keyword) indexes for an instance without running keyword index regen.

    1. Log in as Voyager.

    2. cd to regen directory.
    For example, cd /m1/incoming/regen/xxxdb (where xxxdb is the Voyager Database Instance)

    3. Run the following command to access xxxdb environment:

    dlib xxxdb

    4. Run the following sql command.

    sqlplus $USERPASS < indexes.all.script


    xxxdb: Voyager DB instance
    Note that indexes.all.script rebuilds every index on every table.

    Category: Voyager

    • Article last edited: 7/31/2014