'Can't enable a foreign key in ORACLE SQL

So I have a disabled foreign key (Manager_ID in the table Employees) and I wanted to enable it, but I get this error:

ORA-02298: cannot validate (my_username.EMP_MANAGER_FK) - parent keys not found

And this is the code:

ALTER TABLE Employees ENABLE CONSTRAINT EMP_MANAGER_FK;

Here's how the table was created:

 CREATE TABLE  "EMPLOYEES" 
   (    "EMPLOYEE_ID" NUMBER(6,0), 
    "FIRST_NAME" VARCHAR2(20), 
    "LAST_NAME" VARCHAR2(25) CONSTRAINT "EMP_LAST_NAME_NN" NOT NULL ENABLE, 
    "EMAIL" VARCHAR2(25) CONSTRAINT "EMP_EMAIL_NN" NOT NULL ENABLE, 
    "PHONE_NUMBER" VARCHAR2(20), 
    "HIRE_DATE" DATE CONSTRAINT "EMP_HIRE_DATE_NN" NOT NULL ENABLE, 
    "JOB_ID" VARCHAR2(10) CONSTRAINT "EMP_JOB_NN" NOT NULL ENABLE, 
    "SALARY" NUMBER(8,2), 
    "COMMISSION_PCT" NUMBER(2,2), 
    "MANAGER_ID" NUMBER(6,0), 
    "DEPARTMENT_ID" NUMBER(4,0), 
    "BONUS" VARCHAR2(5), 
     CONSTRAINT "EMP_SALARY_MIN" CHECK (salary > 0) ENABLE, 
     CONSTRAINT "EMP_ID_PK" PRIMARY KEY ("EMPLOYEE_ID")
   USING INDEX  ENABLE, 
     CONSTRAINT "EMP_EMAIL_UK" UNIQUE ("EMAIL")
   USING INDEX  ENABLE
    )
   /
   ALTER TABLE  "EMPLOYEES" ADD CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY 
    ("DEPARTMENT_ID")
      REFERENCES  "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE
    /
ALTER TABLE  "EMPLOYEES" ADD CONSTRAINT "EMP_JOB_FK" FOREIGN KEY ("JOB_ID")
      REFERENCES  "JOBS" ("JOB_ID") ENABLE
/
ALTER TABLE  "EMPLOYEES" ADD CONSTRAINT "EMP_MANAGER_FK" FOREIGN KEY ("MANAGER_ID")
      REFERENCES  "EMPLOYEES" ("EMPLOYEE_ID") DISABLE
/

CREATE INDEX  "EMP_DEPARTMENT_IX" ON  "EMPLOYEES" ("DEPARTMENT_ID")
/

CREATE INDEX  "EMP_JOB_IX" ON  "EMPLOYEES" ("JOB_ID")
/

CREATE INDEX  "EMP_MANAGER_IX" ON  "EMPLOYEES" ("MANAGER_ID")
/

CREATE INDEX  "EMP_NAME_IX" ON  "EMPLOYEES" ("LAST_NAME", "FIRST_NAME")
/
sqloracleforeign-keysconstraintsoracle-apexpythonmacoskeyboard-shortcuts


Solution 1:[1]

If you want to insert the data anyhow, you can disable the constaint EMP_MANAGER_FK and enable it with NOVALIDATE keyword.

ALTER TABLE EMPLOYEES MODIFY CONSTRAINT EMP_MANAGER_FK ENABLE NOVALIDATE;

ENABLE NOVALIDATE means the constraint is checked for new or modified rows, but the existing data may violate the constraint.

Solution 2:[2]

(Tested on GNU/Linux)This will listen globally on the system, but I don't know if it will prevent the shortcut from sending:

import keyboard

keyboard.add_hotkey('ctrl + shift + z', print, args=('Shortcut detected',))

keyboard.wait('esc')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 user3779043
Solution 2 Emil105

Related Questions