Foreign Key Integrity Constraints

Could someone tell me if what I am trying to do is possible.

(1) I have setup Foreign key constraints on a table and used
the exceptions into clause as below.

alter table order_header

      add constraint fk_customer_cd
      foreign key (customer_cd,record_source_ind)
      references customer_master (customer_cd,record_source_ind)
      exceptions into exceptions_order_header;

(2) I disable all constraints and load the table using SQL*LDR

(3) I enable the constraints and I get the following error message:
alter table order_header
*
ERROR at line 1:
ORA-02298: cannot enable constraint (SALESSYS.FK_CUSTOMER_CD) - parent keys not found

Should these records that violate the constraint no be moved to the exceptions table?

Any help would be much appreciated.

Thanks,
Carol Kilner
BASF Canada
kilnerc_at_basf-corp.com Received on Tue Sep 10 1996 - 00:00:00 CEST