Re: script to drop/create schema indexes

  • From: "goran bogdanovic" <goran00@xxxxxxxxx>
  • To: premjhere@xxxxxxxxx
  • Date: Fri, 27 Jul 2007 16:10:38 +0200

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 .
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 .


Other related posts: