Search notes:

Oracle: Index Organized Tables

create table tab_iot (
   id    integer,
   col_1 …
   --
   constraint tab_iot_pk primary key(id)
)
organization index
-- nologging
-- pctfree 0
;

Finding index organized tables in the data dictionary

The list of index organized tables can be queried from the data dictionary like so: 
select
   owner,
   table_name
from
   all_tables
where
   iot_type is not null;

Determine size of IOT

select
   seg.blocks,
   round(seg.bytes / 1024/1024/1024, 2) giga_bytes
from
   user_constraints con  join
   user_segments    seg on con.constraint_name = seg.segment_name
where
   con.table_name      = 'TABLE_NAME' and
   con.constraint_type = 'P'
;

See also

Creating an IOT with a create table … as select statement.
An index organized table cannot have virtual columns, see ORA-54008: expression column is not supported for an index organized table.
$ORACLE_HOME/rdbms/admin/dbmsiotc.sql.
Apparently, the equivalent of IOTs in MySQL are referred to as clustered indexes.
ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758200477, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/objects/tables/organization/iot/index(81): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78