Index

How to Resolve ORA-01418: specified index does not exist

by Ed Chen
September 30, 2022September 20, 2022

ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »

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

by Ed Chen
May 11, 2022September 25, 2022

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 Create Case-Insensitive Unique Index

by Ed Chen
April 29, 2022May 25, 2022

Case Insensitive Index Using unique case-insensitive constraint in a column sometimes is reasonable in business logic to prevent duplicate items. Let's see a table that… Read More »

Alter Index Rebuild to Another Tablespace

by Ed Chen
December 3, 2021September 22, 2022

Move Index To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options like ONLINE… Read More »

How to Resolve ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

by Ed Chen
September 10, 2021February 3, 2022

ORA-02243 The root cause of ORA-02243 may vary in different operations, so the case in this post may not fit your situation. Tried to move… Read More »

How to Resolve ORA-01502 Error Message

by Ed Chen
June 12, 2021May 14, 2022

ORA-01502: index or partition of such index is in usable state ORA-01502 means that the index that the optimizer want to use is in UNUSABLE… Read More »

How to Create a Non-unique Primary Key in Oracle

by Ed Chen
December 16, 2020July 2, 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 »

Oracle DROP INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. DROP INDEX Syntax for Oracle Database 21c DROP INDEX Syntax for… Read More »

Oracle ALTER INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. ALTER INDEX syntax for Oracle Database 21c ALTER INDEX syntax for… Read More »

Oracle CREATE INDEX Syntax for All Releases

by Ed Chen
July 4, 2020January 23, 2021

Here is the list of CREATE INDEX Syntax for All Releases of Oracle Database. CREATE INDEX Syntax for Oracle Database 21c CREATE INDEX Syntax for… Read More »