Create IOT

Basic IOT:

create table SM_IOT (id NUMBER PRIMARY KEY, value VARCHAR2(120)) ORGANIZATION INDEX;

IOT with custom named Index/PK name:

create table SM_IOT (id NUMBER CONSTRAINT sm_iot_idx PRIMARY KEY, value VARCHAR2(120)) ORGANIZATION INDEX;

IOT with overflow. LOOKUP is included in the index segment. Columns following LOOKUP are in the OVERFLOW!

create table SM_IOT3 (id NUMBER PRIMARY KEY, value VARCHAR2(120), lookup VARCHAR2(20),</pre>
comments VARCHAR2(2000)) ORGANIZATION INDEX INCLUDING lookup OVERFLOW;