Index-organized tables

From: Pavel Vetesnik <Pavel.Vet_at_volny.cz>
Date: Fri, 29 Aug 2003 10:29:40 +0200
Message-ID: <bin2q6$1rgl$1@ns.felk.cvut.cz>

Hello,

is it possible to modify (alter) index-organized table? In documentation I read, that "you cannot ADD columns to an index-organized table, but you can alter the definition of an index-organized table.". But it seems I can do it.

To following code surprisingly works for me:

---

CREATE TABLE source_type
(short_name CHARACTER(3) PRIMARY KEY,
 name VARCHAR2(25) UNIQUE)
ORGANIZATION INDEX
STORAGE (INITIAL 20k NEXT 10k PCTINCREASE 0);

ALTER TABLE source_type ADD (some_column VARCHAR2(500))

---

So how it is? Can IOT table be modified or not (or sometimes not).

Do you think it is good idea to use IOTs for small lookup tables, that are updated very seldom?

Thank you in advance,
Pavel Received on Fri Aug 29 2003 - 03:29:40 CDT