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-23315: repcatlog version or request string is not supported by version string
ORA-08175: discrete transaction restriction violated (string)
DRG-50942: errors: stringstring
ORA-30937: No schema definition for 'string' (namespace 'string') in parent 'string'
NNL-00582: dump_alias: dump aliases in the domain or region to LDAP
O2I-00122: Invalid filename for the INITFILE file
LSX-00009: data missing for type "~S"
ORA-25233: invalid parameter specified for NAVIGATION
RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row
ORA-24783: Cannot switch non-migratable transactions
ORA-34346: (MXDSS04) The string analytic workspace cannot be detached.
ORA-30458: 'string.string' cannot be refreshed because the refresh mask is string