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
How Oracle Disable NOT NULL Constraintby Ed ChenNovember 23, 2019December 8, 2021After you add a NOT NULL constraint to a column, you might want it stop temporarily. In such moment, you should consider to disable NOT… Read More »How Oracle Disable NOT NULL Constraint