How to Resolve ORA-02243 Error Message
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option The root cause of ORA-02243 may vary in different operations, so the case in this post… Read More »How to Resolve ORA-02243 Error Message
Index
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
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
Oracle DROP INDEX Syntax for All Releases
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 DROP INDEX Syntax for All Releases
Oracle ALTER INDEX Syntax for All Releases
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 ALTER INDEX Syntax for All Releases
Oracle CREATE INDEX Syntax for All Releases
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 »Oracle CREATE INDEX Syntax for All Releases
How to Create Index for Other User's Table
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 »How to Create Index for Other User's Table
How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key
ORA-02429 ORA-02429 means that the index you want to drop is a primary key. SQL> drop index hr.JHIST_EMP_ID_ST_DATE_PK; drop index hr.JHIST_EMP_ID_ST_DATE_PK … Read More »How to Resolve ORA-02429: cannot drop index used for enforcement of unique/primary key
How to Resolve ORA-12991 Error Message
ORA-12991: column is referenced in a multi-column constraint ORA-12991 means that the column you want to drop is bound to some multi-column constraints. You must… Read More »How to Resolve ORA-12991 Error Message
How Oracle Modify Primary Key
Modify Primary Key Sometimes, developers may design a better primary key to support the uniqueness of a table and they want to replace the current… Read More »How Oracle Modify Primary Key