Re: script to drop/create schema indexes

JP,

My simple-minded solution would be to export the schema with Rows=N, then 
import using the IndexFile parameter.  You'll get all the Create Index 
statements in a text file that you can edit and run.  Check out the 
Utilities doc.

I'm sure there are newer, cooler 10g facilities for this, but I'm not 
there yet.

Jack C. Applewhite - Database Administrator
Austin (Texas) Independent School District
512.414.9715 (wk)  /  512.935.5929 (pager)

 I'll just sit back in the shade while everyone gets laid.
 That's what I call Intelligent Design. -- God ("Origin of Species": Chris 
Smither)




"Prem Khanna J" <premjhere@xxxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
07/27/2007 09:28 AM
Please respond to
premjhere@xxxxxxxxx


To
oracle-l <oracle-l@xxxxxxxxxxxxx>
cc

Subject
script to drop/create schema indexes






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~

Other related posts: