ORA-02273: this unique/primary key is referenced by some
foreign keys
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-31163: element or attribute "string" has invalid attribute value "string" (should be "string")
NZE-28863: SSL session not found
ORA-31632: master table "string.string" not found, invalid, or inaccessible
ORA-01051: deferred rpc buffer format invalid
LRM-00104: 'string' is not a legal integer for 'string'
ORA-01345: Supplemental log data must be enabled to build into the logstream
PCC-02202: No typedef name was given
PLS-00533: Tables of non_queryable types are not supported.
ORA-13913: The threshold cannot be set when SYSAUX is offline.
TNS-04079: Cannot administer Oracle Connection Manager with no CMAN.ORA, and port = number.
ORA-24064: propagation for QUEUE string and DESTINATION string already enabled
ORA-01662: tablespace 'string' is non-empty and cannot be made temporary