Fix ORA-02273: this unique/primary key is referenced by some foreign keys
32,489
select * from all_constraints
where constraint_type='R' and r_constraint_name='YOUR_CONSTRAINT';
Comments
-
wheleph over 3 years
Trying to drop a unique constraint I've got such error:
ORA-02273: this unique/primary key is referenced by some foreign keys
How to find the list of foreign keys by which my unique constraint is referenced?