How to Resolve ORA-01502 Error Messageby Ed ChenJune 12, 2021May 14, 2022ORA-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
Oracle DROP INDEX Syntax for All Releasesby Ed ChenJuly 4, 2020January 23, 2021Here 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
How Oracle Drop Primary Keyby Ed ChenApril 22, 2020April 27, 2022Drop Primary Key Primary key is sort of a constraint rather than an index, you should treat it as a constraint first so as to… Read More »How Oracle Drop Primary Key