I need Help for error ORA-02291

[nouralai1]

ALTER TABLE LEASE_2 
    ADD CONSTRAINT CLIENT_LEASE FOREIGN KEY 
    ( 
     CLIENT_ID1
    ) 
    REFERENCES CLIENT_2 
    ( 
     CLIENT_ID
    ) 
    ON DELETE CASCADE 

Error starting at line 244 in command:
Insert into STUDENT.LEASE_2 (LEASE_ID,MONTHLY_RENT,PAYMENT_TYPE,DURATION_OF_LE ASE,LEASE_START_DATE,LEASE_END_DATE,PROPERTY_ID,CL IENT_ID1) values
(1,130000,'CASH','TWO YEARS',to_date('13-SEP-12','DD-MON-RR'),to_date('13-SEP-14','DD-MON-RR'),1,123)


Error starting at line 245 in command:
Insert into STUDENT.LEASE_2 (LEASE_ID,MONTHLY_RENT,PAYMENT_TYPE,DURATION_OF_LE ASE,LEASE_START_DATE,LEASE_END_DATE,PROPERTY_ID,CL IENT_ID1) values
(1,130000,'CASH','TWO YEARS',to_date('13-SEP-12','DD-MON-RR'),to_date('13-SEP-14','DD-MON-RR'),1,123)


Error report:
SQL Error: ORA-02291: integrity constraint (STUDENT.LEASE_RENT) violated - parent key not found
02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"
*Cause: A foreign key value has no matching primary key value.
*Action: Delete the foreign key or add a matching primary key.

[Rabbit]

Please use code tags when posting code.


It's a fairly clear error message. It's saying that your foreign keys have no matching primary key in the contraint that you are creating. The error message even tells you how to fix it: Delete the foreign key or add a matching primary key.