Partitioning Tables  «Prev 

Syntax of Partitioned index-organized Table

Syntax and an example of partitioned index-organized table

Location 1 A primary key is required for an index-oriented table.
Location 2 This clause tells Oracle that the table is an index-oriented table. There are some optional parameters that can be added to this clause that we are not displaying. See Oracle SQL Reference document for details.
Location 3 Include optional storage clauses here such as TABLESPACE, PCTFREE, and PCTUSED.
Location 4 Define the partitions here. Remember that the column list must be the same as the PRIMARY KEY column list.