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.
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