Hello,

is it possible to modify (alter) index-organized table?
In doentation 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