Re: how to drop all indexes?

Bad Boy Street,

select 'DROP INDEX '||index_name||';'
from user_indexes;

spool it off to "x.sql" and then
@x.sql

This might be problematic if u use primary keys constraints, you might have to elaborate on this script.

Regards,

badstreetboy_at_yahoo.com wrote:

> 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 Fri Feb 19 1999 - 15:29:46 CST