Index

How to Resolve ORA-00953: missing or invalid index name

by Ed Chen
May 18, 2023May 26, 2023

ORA-00953 Tried to create an index for a table, but it failed with ORA-00953. Reserved Word SQL> create index update on products (patch_date); create index… Read More »

How Oracle Rename Index

by Ed Chen
October 6, 2022November 17, 2022

ALTER INDEX RENAME TO Traditional ALTER INDEX statement is able to rename the index. Login as Owner You can change the index name by the… Read More »

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

by Ed Chen
September 30, 2022December 23, 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 »

Create Case-Insensitive Unique Index in Oracle

by Ed Chen
April 29, 2022May 27, 2023

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, 2021March 27, 2023

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, 2021December 22, 2022

ORA-02243 The root cause of ORA-02243 may vary in different operations. Let's see some cases. LOB INDEX REBUILD ONLINE LOB INDEX In some situations, you… Read More »

How to Resolve ORA-01502 Error Message

by Ed Chen
June 12, 2021February 6, 2023

ORA-01502: index or partition of such index is in unusable 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, 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 »

DROP INDEX Syntax for All Releases of Oracle Database

by Ed Chen
July 4, 2020December 9, 2022

Here is the list of DROP INDEX Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. DROP… Read More »

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