Hi,

I am trying to create index TABLE_POSITION_A_IDX2 ON TABLE_POSITION_ADJ


CREATE INDEX TABLE_POSITION_A_IDX2 ON TABLE_POSITION_ADJ
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
but it gives me following error
ORA-00955: name is already used by an existing object

but when i try to drop the index by
drop index TABLE_POSITION_A_IDX2 it says
ORA-01418: specified index does not exist

WHY!!
please help!!