title: Issue with creating index organized table
body: <p>I'm having a weird problem with index organized table. I'm running Oracle 11g standard. </p>
  
  <p>i have a table src_table</p>
  
  <pre><code>SQL&gt; desc src_table;
   Name            Null?    Type
   --------------- -------- ----------------------------
   ID     NOT NULL   NUMBER(16)
   HASH       NOT NULL   NUMBER(3)
   ........
  
  SQL&gt; select count(*) from src_table;
    COUNT(*)
  ----------
    21108244
  </code></pre>
  
  <p>now let's create another table and copy 2 columns from src_table</p>
  
  <pre><code>set timing on
  SQL&gt; create table dest_table(id number(16), hash number(20), type number(1));
  Table created.
  Elapsed: 00:00:00.01
  
  SQL&gt; insert /*+ APPEND */ into dest_table (id,hash,type) select id, hash, 1 from src_table;
  21108244 rows created.
  Elapsed: 00:00:15.25
  
  SQL&gt; ALTER TABLE dest_table ADD ( CONSTRAINT dest_table_pk PRIMARY KEY (HASH, id, TYPE));
  Table altered.
  Elapsed: 00:01:17.35
  </code></pre>
  
  <p>It took Oracle &lt; 2 min.</p>
  
  <p>now same exercise but with IOT table</p>
  
  <pre><code>SQL&gt; CREATE TABLE dest_table_iot (
         id     NUMBER(16) NOT NULL,
         hash  NUMBER(20) NOT NULL,
         type  NUMBER(1)  NOT NULL,
         CONSTRAINT dest_table_iot_PK PRIMARY KEY (HASH, id, TYPE)
      ) ORGANIZATION INDEX;
  
  Table created.
  Elapsed: 00:00:00.03
  
  SQL&gt; INSERT /*+ APPEND */ INTO dest_table_iot (HASH,id,TYPE)
      SELECT  HASH, id, 1 
      FROM src_table; 
  </code></pre>
  
  <p>"insert" into IOT  takes <strong>18 hours</strong> !!! I have tried it on 2 different instances of Oracle running on win and linux and got same results.</p>
  
  <p>What is going on here ? Why is it taking so long ? </p>