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-00484: LMS* process terminated with error
ORA-01212: MAXLOGMEMBERS may not exceed string
In VB program, I got message as " No Transaction is Active" , Backend database is Oracle, This message is coming some user's PC and Not all user's PC Please help me to resolve this issue
ORA-22852: invalid PCTVERSION LOB storage option value
NZE-28788: user provided invalid information, or an unknown error
PCC-02404: This indicator variable must be declared as a pointer type
ORA-27041: unable to open file
PLS-00462: nested subprogram 'string' has to be REPEATABLE
ORA-30055: NULL snapshot expression not allowed here
ORA-07444: function address string is not readable
ORA-23620: bind value size too large for PL/SQL CALL operation
ORA-31456: error executing a procedure in the DBMS_CDC_UTILITY package