-
SQL Loader Error
I am getting the following error when using the SQL loader:
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table "SCOTT"."SOURCE"
ORA-02292: integrity constraint (SCOTT.FK_ORD_SOURCE) violated - child record found.
In the control file I am loading data with the REPLACE option.
Please explain.
Chintz
-
Sql*loader can not delete your existing records before loading new ones because you have existing records in child-related table. Either disable that constraint FK_ORD_SOURCE or remove all rows from that child table.