Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Martin H.Aug 12 2020 — edited Aug 13 2020

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;

This post has been answered by Martin H. on Aug 13 2020
Jump to Answer
Comments
Post Details
Added on Aug 12 2020
1 comment
709 views