Search notes:

ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces

With block size = 8KB, the following statement throws ORA-01429: Index-Organized Table: no data segment to store overflow row-pieces:

create table tq84_ora_01429 (
   id integer primary key,
   txt varchar2(4000)
)
ORGANIZATION INDEX;

With the overflow tablespace clause, the index organized table can be created:

create table tq84_no_ora_01429 (
   id integer primary key,
   txt varchar2(4000)
)
organization index
OVERFLOW TABLESPACE user_data;

See also