you may use dbms_metadata package to get ddl for indexes in question... Prem Khanna J wrote: Friends , I want to drop/create all indexes of a schema. This is on 10.2.0.2/AIX5.3L . Thought I don't want to do it (i want to go for rebuild) , my irate customer wants it dropped/created. I couldn't convince him . Does someone has a good script to do that ? If someone can share it with me, it would be great. Thanks . ~jp~