>is there any Generic routine available for repairing Indexes in Database ?

SDT from http://www.stonefield.com

You can use it to either repair (using REINDEX) or by using its meta data of of our tables and indexes to recreate the indexes uning the INDEX ON command. It has other database synchronization features to update your customer's data files as well. Well worth the cost.