How to Check Primary Key in Oracle
For 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
DBA_CONSTRAINTS
How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys
ORA-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