Index

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

by Ed Chen
May 11, 2022May 27, 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 »

How Oracle Move Index to Another Tablespace

by Ed Chen
December 3, 2021May 14, 2022

Alter Index Rebuild Tablespace To move an index is to rebuild a whole index either in the original tablespace or another tablespace with some options… 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

by Ed Chen
December 16, 2020September 22, 2021

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 »

How to Create Index for Other User's Table

by Ed Chen
June 13, 2020October 24, 2021

The answer is positive, you can create indexes for tables belonging to other users in your own schema, but you need more privileges. Try the… Read More »