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

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

script to drop/create schema indexes

From: Prem Khanna J <premjhere_at_gmail.com>
Date: Fri, 27 Jul 2007 19:08:43 +0530
Message-ID: <56d3d5610707270638r7c34317do462ac2dcc4888125@mail.gmail.com> 





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 - 08:38:43 CDT












Original text of this message













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