ALTER INDEX REBUILD ONLINE

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 »

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 »

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