The next script will allow the DBA to rebuild all indexes in a database, since Oracle will not allow multiple indexes on the same set of columns, running the resulting DDL after rebuilding your constraints will allow creation of any look up indexes without the possibility of damaging already existing indexes used in support of primary, unique or foreign key constraints. sql REM REM FUNCTION: SCRIPT FOR CREATING INDEXES REM REM This script must be run by a user with the DBA role. REM REM This script is intended to run with Oracle7.