Re: how to drop all indexes?

Use a script to generate the sql to drop indexes along the lines of:

set head off
spool dropidx.sql
select 'drop index '|| index_name ' ;'
from user_indexes;

then run the script dropidx.sql

Do all this as the schema user and should work fine --
Greg Cooper
IT Services Central West / Regional Technologies / Information Technologist Ph 08 8401 7252 Fax 08 8410 0023 Mobile 0419 823 225

badstreetboy_at_yahoo.com wrote in article <7akh9e$87l$1_at_nnrp1.dejanews.com>...
> Hi all,
>
> An application developed by one of our developr required to drop all
indexes
> within the schema. And the number and name of index is different from
time
> to time so I can't make a script to drop one by one. I would like to
know is
> there a way to drop all indexes within the schema?
>
> Thanx.
>
> BSB
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Wed Mar 03 1999 - 17:15:54 CST