René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

create table (index organized) [Oracle SQL]

create table iot-table-name 
(            
  relational-properties
)
organization index
[ segment-attributes ] 
[ iot-table-clause ]
[ table-properties  ]
The organization index makes the table be a heap table.

Primary key

An index organized table cannot be created without specifying a primary key. If no primary key is specified, Oracle will issue an ORA-25175: no PRIMARY KEY constraint found.
The primary key can either be specified as inline constraint .... 
create table iot_inline_pk (
  num number primary key,
  str varchar2(10)
)
organization index;
... or out of line constraint: 
create table iot_out_of_line_pk (
  num number,
  str varchar2(10),
  dt  date,
  primary key (num, str)
)
organization index;