I have droped the index and created index using this query:

Create index <name> tablespace <name>;
The result is index created.
After I have checked the dba_indexes for this table,but it shown no indexes.
Again I have tried to craete the index with the same name,the result is
"name already used".
I used different name and tried ,result is "the columns already indexed".
I tried to drop the index ,the result is "specified index does not exist".

Please help me to over come this error.


-----Original Message-----
From: Thiyagaraj
[mailto:oracledba-ezmlmshield-x30422524.[Email address protected]
Sent: Saturday, May 05, 2007 1:34 PM
To: LazyDBA Discussion
Subject: Drop index Online



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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a dba
job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com To
unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page