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 |
NNC-00431: NS address does not match any of the current addresses
ORA-10621: data block does not belong to the segment
ORA-26680: object type not supported
TNS-00535: Failed to send or receive disconnect message
ORA-38408: The ADT "string" does not exist in the current schema.
ORA-31477: could not detach LogMiner session during cleanup
PLS-00378: invalid compilation unit for this release of PL/SQL
NNL-00349: Configuration will be saved in string
LCD-00212: runaway quoted string [string]
DRG-12228: maximum number of field sections (string) exceeded
RMAN-06057: a standby controlfile cannot be included along with a current controlfile
ORA-39111: Dependent object type string skipped, base object type string already exists