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(
CONSTRAINT pk_t01 PRIMARY KEY (s1)
) ORGANIZATION INDEX;
I have found the answer finally. The behaviour is one of many restrictions of ATP: