Index-Organized Table (IOT)

How to Resolve ORA-25182: feature not currently available for index-organized tables

by Ed Chen
October 5, 2023September 7, 2023

ORA-25182 Found ORA-25182 when I tried to move an index-organized table to another tablespace. SQL> ALTER TABLE ERPAPP.CONFIG MOVE TABLESPACE ERP_TBS_01 ONLINE PARALLEL 16; ALTER… Read More »

How to Resolve ORA-28650: Primary index on an IOT cannot be rebuilt

by Ed Chen
May 11, 2022September 5, 2023

ORA-28650 Tried to move and rebuild an index to another tablespace, but it failed with ORA-28650. SQL> alter index hr.country_c_id_pk rebuild tablespace users online; alter… Read More »

How to Resolve ORA-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster

by Ed Chen
May 15, 2021March 23, 2021

ORA-25188 There're some restrictions on using index-organized tables (IOT). This is one case of them. SQL> alter table ERPAPP.PAY_EXT_P drop constraint XM500P0; alter table ERPAPP.PAY_EXT_P… Read More »

How to Resolve ORA-25176: storage specification not permitted for primary key

by Ed Chen
May 5, 2021May 13, 2022

ORA-25176 When I tried to modify an attribute of an index like the following, I got ORA-25176: storage specification not permitted for primary key. SQL>… Read More »

JavaScript is not enabled. Please enable it and reload the page.