CRE_IND.SQR

This program creates an SQL script which will recreate indexes. It knows how to deal with primary keys. May be run for a specific index, all indexes of a table, or all indexes in a User. It calculates the storage parameters according to current usage. Useful for recreating indexes with many extents, or indexes in the wrong tablespace. Also good if you want to change index names or the order in which they are created in the database. Run in your Oracle user (scott/tiger or whatever).

Contributed by Chanan Morrison, chananm@netvision.net.il.

Download CRE_IND.SQR.

Send comments and questions to the SQRUG Librarian.

Go to SQR Users Group Home Page.

File last modified 20-DEC-1997.