How to Resolve ORA-01502 Error Messageby Ed ChenJune 12, 2021February 6, 2023ORA-01502: index or partition of such index is in unusable 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 Resolve ORA-01400: cannot insert NULL intoby Ed ChenNovember 27, 2019May 29, 20232 CommentsORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »How to Resolve ORA-01400: cannot insert NULL into
How Oracle Disable NOT NULL Constraintby Ed ChenNovember 23, 2019December 10, 2022After 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
How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keysby Ed ChenDecember 17, 2016May 25, 2023ORA-02266 ORA-02266 means that you can't truncate the table because reference keys constraint still depend on the data of the table. Truncate a Single Table… Read More »How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys