Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: script to drop/create schema indexes
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~
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 27 2007 - 09:10:38 CDT