Originally posted by greddy
Hi

We are trying to create a datamart by keeping all the
tables as index organized, we started creating the
tables and found that for Index Organized Primary
key column is mandatory i.e you cannot create index
organized table unless you have a column with unique
values and a primary key on that column, any ideas
why primary key is required,
Thanks
Why would you want to create an IOT without a primary key. See http://otn.oracle.com/docs/products/...chem.htm#11141 for concepts.