Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Index organized table
"Thomas Kellerer" <NNGNVRDSJEBN_at_spammotel.com> a écrit dans le message de
news:3ata11F6bvbkjU1_at_individual.net...
| 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
You can't name the index of an IOT
You can't change an heap organized table to an IOT
Regards
Michel Cadot
Received on Tue Mar 29 2005 - 10:00:37 CST