Retour
-
Titre
Getting ORA-00001 unique constraint (STAT.MERC_BUS_RULE_PK1) violated error creating personal rule -
Description
Getting ORA-00001 unique constraint (STAT.MERC_BUS_RULE_PK1) violated error creating personal rule -
Cause
Reached RULE_LAST_NUMBER -
Résolution
Solution.1. Run the query below from sqlplus or Toad session against Stat DB:UPDATE SYSTEM_TBL SET RULE_LAST_NUMBER = (SELECT MAX(RULE_ID) FROM MERC_BUS_RULE);COMMIT;