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

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

Procedure:
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


Note:

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

Category: Voyager

• Article last edited: 7/31/2014