ORA-02273: this unique/primary key is referenced by some foreign keys

ORA-02273: this unique/primary key is referenced by some
foreign keys

Question Posted / guest

2 Answers
20723 Views
KIIT, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-02273: this unique/primary key is referenced by some foreign keys..

Answer / muzafar

Query to find the references

select * from all_constraints
where constraint_type='R' and
r_constraint_name='YOUR_CONSTRAINT_NAME';

OR DROP THE PRIMARY AND FORIGN KEY WITH THIS COMMAN

Query to find the references

alter table InISMast drop primary key cascade;

Is This Answer Correct ?

4 Yes

2 No

ORA-02273: this unique/primary key is referenced by some foreign keys..

Answer / guest

Cause: Self-evident.

Action: Remove all references to the key before the key is
to be dropped.

Please add more information about this Error

Is This Answer Correct ?

2 Yes

1 No

Post New Answer