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-30118: syntax error at 'string' at the end of input
ORA-02203: INITIAL storage options not allowed
ORA-30379: query txt not specified
EXP-00012: %s is not a valid export mode
ORA-13144: target table string not found
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
TNS-00258: Number of Failed Requests : number
NNL-01003: NON LEAF responses received: number
NID-00130: Mismatched CHECKPOINT_CHANGE# in datafile "string", expecting string, found string
ORA-16587: Ambiguous object specified to Data Guard broker
ORA-02249: missing or invalid value for MAXLOGMEMBERS
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit