Hi

Can I drop the index online?If so,can anyone tell me the syntax?If I do
so on the live server,what could be the effects that will affect the
transaction?

Or else,can I first make the index unusable:

Alter index <name> unusable;

And the drop normal:

Drop index <name>;

If I do like this what will be the effect of the transactions currently
running on the DB.

Please suggest me with the safer steps to be followed.

-Raaj


Oracle LazyDBA home page