How Oracle Rename Index
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 Oracle Rename Index
Index
How to Resolve ORA-01418: specified index does not exist
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-01418: specified index does not exist
How to Resolve ORA-28650: Primary index on an IOT cannot be rebuilt
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 Resolve ORA-28650: Primary index on an IOT cannot be rebuilt
How to Create Case-Insensitive Unique Index
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 »How to Create Case-Insensitive Unique Index
Alter Index Rebuild to Another Tablespace
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 »Alter Index Rebuild to Another Tablespace
How to Resolve ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
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-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option
How to Resolve ORA-01502 Error Message
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 Resolve ORA-01502 Error Message
How to Create a Non-unique Primary Key in Oracle
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 »How to Create a Non-unique Primary Key in Oracle
DROP INDEX Syntax for All Releases of Oracle Database
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 »DROP INDEX Syntax for All Releases of Oracle Database
ALTER INDEX Syntax for All Releases of Oracle Database
Here is the list of ALTER INDEX Syntax for All Releases of Oracle Database. You may press Ctrl + d to bookmark this page. ALTER… Read More »ALTER INDEX Syntax for All Releases of Oracle Database