Re: Multiple FK constraint question

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1997/08/20
Message-ID: <33FAB412.D35@adra.se>#1/1

Kelly wrote:
> Is
> it allowable for have 2 FK constraints (or more) on a single field in a table?

Yes, I suppose it is but the foreign key value must be present in both of the
primary keys.

> I am having trouble loading this table from SQL Loader with it
> giving an error of:
>
> ORA-02291: integrity constraint (kgrigg.individual_expand_n_fk) violated -
> parent key not found

This implies that at least one primary key value is missing in at least one
of the primary keys.

/Roger Received on Wed Aug 20 1997 - 00:00:00 CDT