Index organized table

Hello,

I'm trying to create an index organized table, and at the same time give the index a proper name.

CREATE TABLE xyz
(

   ID1 VARCHAR2(30) NOT NULL,
   ID2 VARCHAR2(30) NOT NULL,
   PRIMARY KEY (ID1, ID2)
)
ORGANIZATION INDEX
;

which will create the table correctly, but creates an index named SYS_something.

I tried

CREATE TABLE xyz
(

   ID1 VARCHAR2(30) NOT NULL,
   ID2 VARCHAR2(30) NOT NULL
)
;

ALTER TABLE xyz

   ADD CONSTRAINT PK_ID_MAPPING PRIMARY KEY (ID1, ID2)        USING INDEX
;

which works fine - the index gets the proper name. But then the table is not index organized and I can't seem to figure out how to do an ALTER TABLE to make the table index organized.

What am I missing here?

Thanks in advance
Thomas Received on Tue Mar 29 2005 - 09:20:00 CST