Index

How to Resolve ORA-14086: a partitioned index may not be rebuilt as a whole

by Ed Chen
October 23, 2023October 17, 2023

ORA-14086 Saw an error when we were trying to rebuild the index to another tablespace. SQL> alter index sh.sales_cust_bix rebuild tablespace users online; alter index… Read More »

Alter Index Rebuild Partition to Another Tablespace

by Ed Chen
October 19, 2023October 19, 2023

Rebuild Index Partition Yes, index can be partitioned. Since a partitioned index has many segments, we cannot rebuild the partitioned index as a whole. That… Read More »

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-01702: a view is not appropriate here

by Ed Chen
June 27, 2023August 25, 2023

ORA-01702 Tried to create an index, but it failed with ORA-01702. SQL> create index emp_salary on happy_employees (salary); create index emp_salary on happy_employees (salary) … Read More »

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 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 »

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, 2021October 25, 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 »

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