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

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

More Oracle Errors Interview Questions

ORA-31163: element or attribute "string" has invalid attribute value "string" (should be "string")

1 Answers  


NZE-28863: SSL session not found

1 Answers  


ORA-31632: master table "string.string" not found, invalid, or inaccessible

1 Answers  


ORA-01051: deferred rpc buffer format invalid

1 Answers  


LRM-00104: 'string' is not a legal integer for 'string'

1 Answers  






ORA-01345: Supplemental log data must be enabled to build into the logstream

1 Answers  


PCC-02202: No typedef name was given

1 Answers  


PLS-00533: Tables of non_queryable types are not supported.

1 Answers  


ORA-13913: The threshold cannot be set when SYSAUX is offline.

1 Answers  


TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.

1 Answers  


ORA-24064: propagation for QUEUE string and DESTINATION string already enabled

1 Answers  


ORA-01662: tablespace 'string' is non-empty and cannot be made temporary

1 Answers  


Categories