Re: index created for use as a table

The feature is called Indexed Organized Table, IOT. See the SQL manual entry for Create Table. Note in my example the use of the table constraint clause allows you to control the name assigned to the index.

create table owner.table_name (
 column_list number(5,0)
 ,constraint table_name_pk primary key (key columns) )
 organization index
 tablespace dataspc
 pctfree 10
storage (initial 16K next 16k pctincrease 0 maxextents 32) /

HTH -- Mark D Powell -- Received on Mon Jun 13 2005 - 09:57:59 CDT