1 Reply Latest reply on Aug 13, 2020 8:27 AM by Martin H.

    Unable to create an index organized table in Autonomous Transaction Processing database

    Martin H.

      I am unable to create an index organized table in an always free Autonomous Transaction Processing database.

       

      A simple command below creates an IOT table on my local database while on my always free ATP, an index and a heap organized table are created. Both databases are 19c EE.

      Is this some kind of always free restrictions?

       

      CREATE TABLE t01(

              s1 NUMBER,

              s2 NUMBER,

              CONSTRAINT pk_t01 PRIMARY KEY (s1)

      ) ORGANIZATION INDEX;