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

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 !

When you create your primary key, oracle is creating an index
automatically. By default, the index will be ascending.

If you have different requirements for your pk index, you can create
the table without a pk, create your index and then create the pk using
that index. I've had to do that in a data warehouse environment where
I didn't want a unique index on my pk.

But in your case, it looks the index oracle is creating meets your
indexing needs.

Hope that helps,

Lewis



On 21 Mar 2005 08:30:07 -0800, arxel (AT) caramail (DOT) com (kahriboo) wrote: