How to Check Primary Key in Oracleby Ed ChenApril 15, 2020December 10, 2022For getting the information of a primary key, we have to join two dictionary views, one is ALL_CONS_COLUMNS, the other is ALL_CONSTRAINTS. And then we… Read More »How to Check Primary Key in Oracle
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