Maybe you simplified the statement for you post, but the create index
statement is wrong.

A very basic index create looks something like:-

Create index <index_name> on table_name (column_list) tablespace
<tablespace_name>;

Cheers,

Michael Peel

-----Original Message-----
From: Thiyagaraj
[mailto:oracledba-ezmlmshield-x3611665.[Email address protected]
Sent: 05 May 2007 09:54
To: LazyDBA Discussion
Subject: RE: Drop index Online

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



---------------------------------------------------------------------
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


**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ

AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************


Oracle LazyDBA home page