I read in the Oracle SQL Language Reference manual that all tables are created by default with ORGANIZATION as HEAP which means the rows are stored in no particular order. After that we have the possibility of an INDEX organized table.
So my questions are:
1) How can I verify with certainty which organization type a table is using? I've tried using the DBMS_METADATA.GET.DDL() function and it did not show any ORGANIZATION clause anywhere that I could see. I do see an USING INDEX statement though. Does that mean the table is INDEX-ORGANIZED?
2) If I CREATE TABLE with a PRIMARY KEY column from the beginning does that mean that the table is INDEX-ORGANIZED? Is an index-organized table the same thing as a table that uses regular INDEX objects? Or does this INDEX-ORGANIZED table store the indexes in the same table as the rows of data?
3) If I add an INDEX or PRIMARY KEY(so adding an INDEX implicitly) to my table after creation does it then become an INDEX-ORGANIZED table?