ALL_INDEXES

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-25188: cannot drop/disable/defer the primary key constraint for index-organized tables or sorted hash cluster

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 »How to Resolve ORA-25176: storage specification not permitted for primary key