[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454)
Unsuccessful: alter table user.CEN_USER_MASTER add
constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID)
references user.CEN_ROLE_MASTER
[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454)
ORA-02275: such a referential constraint already exists in
the table
- 1 Answers
- 2813 Views
- HCL, I also Faced
- E-Mail Answers
Answer / Anita
The error ORA-02275 indicates that there is already an existing foreign key constraint with the name 'FKF4EDEDC3D0BAAE75' on the table 'user.CEN_USER_MASTER'. To resolve this issue, either remove or rename the constraint before trying to add a new one with the same name.
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-01906: BACKUP keyword expected
ORA-30104: 'string' is not a legal integer for 'string'
ORA-09365: Windows 3.1 Two-Task driver unable to destroy hidden window
ORA-28530: Heterogeneous Services initialization error in NLS language ID
ORA-06002: NETASY: port read failure
DRG-10595: ALTER INDEX string failed
PCC-02338: structure contains a nested struct or union
ORA-16707: The value of the property string is invalid. The valid values are string.
ORA-36683: (XSDPART21) Partition string dimensioned by more than one composite.
ORA-13432: GeoRaster metadata blankCellValue error
ORA-13446: GeoRaster metadata TRS error
ORA-03209: DBMS_ADMIN_PACKAGE invalid file/block specification
Oracle Errors 
