Tuesday, September 1, 2009

Create IOTs Examples

Some examples on how to create Index Organized tables

1) create table iot_table (a int , b int, primary key (a))
organization index;

2) create table iot_table (a int , b int, primary key (a,b))
organization index tablespace users;

3) create table iot_table (a int , b int, constraint iot_table_pk primary key (a,b))
organization index tablespace users;

No comments:

Post a Comment