Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: script to drop/create schema indexes

Re: script to drop/create schema indexes

From: goran bogdanovic <goran00_at_gmail.com>
Date: Fri, 27 Jul 2007 16:10:38 +0200
Message-ID: <6d0a3ba80707270710q4262e7d0p7e086d69b33ef31@mail.gmail.com>


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-l
Received on Fri Jul 27 2007 - 09:10:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US