ALL_INDEXES

How to Resolve Some indexes or index [sub]partitions of table have been marked unusable

by Ed Chen
July 5, 2023June 16, 2023

Some indexes or index [sub]partitions of table have been marked unusable Saw errors in the alert log file, which indicates that some indexes depends on… 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 »

How to Create a Non-unique Primary Key in Oracle

by Ed Chen
December 16, 2020December 9, 2022

The primary key in a table is just like the spine of a human being, which integrates all data in the table. In practice, we… Read More »

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