create index on a new table

[kahriboo]

Hi everybody !!

Here's my problem :

DROP TABLE Equivalent CASCADE CONSTRAINTS
/

CREATE TABLE Equivalent (
id_equivalent NUMBER(6) NOT NULL,
nom VARCHAR2(50),
est_suppr NUMBER(1) DEFAULT 0 NOT NULL constraint
Equivaet_est_suppr_BOOL check (est_suppr in (1,0)),
CONSTRAINT PKEY_569 PRIMARY KEY (id_equivalent))
/

drop sequence S_Equivaet_id_equvln
/

create sequence S_Equivaet_id_equvln start with 1 increment by 1
nomaxVALUE
/

Everything on top on this work perfectly but when i try :

CREATE INDEX IDX_Equivalent_712 ON Equivalent ( id_equivalent ASC )
/

I say to me that this "list of columns is already indexed" ...

Why ?

It work for other table but not for all... Is the previous index (I
launched this script several times) not deleted when I drop the table
?

If there's a bug how can I found the index that block me and delete it
manually ?

Thanks for any help

Kahriboo

[kahriboo]

Just to say that I found my error...

the index I tried to put was on the primary key so there is already an
index on it...

So I resolved my problem !