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 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~
- Follow-Ups:
- Re: script to drop/create schema indexes
- From: Prem Khanna J
Other related posts:
- » script to drop/create schema indexes
- » Re: script to drop/create schema indexes
- » Re: script to drop/create schema indexes
- » Re: script to drop/create schema indexes
- Re: script to drop/create schema indexes
- From: Prem Khanna J