As you mentioned that you have three foreign keys in DMEPOS_BIDDER, the
column values of ENT_TYPE_CD, SUPLR_ID, and NTWRK_ID should pre-exist in
the table/s that the FKs reference.
Deepthi Samarasinghe
Database Architect
-----Original Message-----
From: Susan Yang
[mailto:oracledba-ezmlmshield-x89310402.[Email address protected]
Sent: Wednesday, November 29, 2006 2:43 PM
To: LazyDBA Discussion
Subject: ORA-02291: integrity constraint violated - parent key not found
Hi All,
I created 4 tables and these 4 tables have primary key and foreign key
relationship.
SQL> desc DMEPOS_BIDDER
Name Null? Type
----------------------------------------- --------
------------------------
BIDDER_NUM NOT NULL CHAR(7)
BIDDER_ENT_NAME VARCHAR2(20)
LAST_CHG_USER_ID VARCHAR2(30)
LAST_CHG_DT DATE
ENT_TYPE_CD CHAR(2)
SPCLTY_PRVDR_IND CHAR(1)
SNF_PRVDR_IND CHAR(1)
PHYSN_PRVDR_IND CHAR(1)
SUPLR_ID NUMBER(38)
NTWRK_ID NUMBER(38)
SQL> desc DMEPOS_SUPPLIER
Name Null? Type
----------------------------------------- --------
------------------------
SUPLR_ID NOT NULL NUMBER(38)
LGL_BUSNS_NAME VARCHAR2(35)
MLG_LINE1_ADR VARCHAR2(35)
MLG_LINE2_ADR VARCHAR2(35)
MLG_CITY_ADR VARCHAR2(35)
MLG_STATE_CD CHAR(2)
MLG_ZIP_CD CHAR(5)
MLG_ZIP_EXTNSN_CD CHAR(4)
BUSNS_PHNE_NUM CHAR(10)
SUPLR_EMAIL_ADR_TXT VARCHAR2(80)
BUSNS_FAX_PHNE_NUM CHAR(10)
LAST_CHG_USER_ID VARCHAR2(30)
LAST_CHG_DT DATE
NSC_NUM CHAR(10)
SQL> desc network
Name Null? Type
----------------------------------------- --------
------------------------
NTWRK_ID NOT NULL NUMBER(38)
LAST_CHG_USER_ID VARCHAR2(30)
LAST_CHG_DT DATE
SQL> desc entity_type
Name Null? Type
----------------------------------------- --------
------------------------
ENT_TYPE_CD NOT NULL CHAR(2)
ENT_TYPE_DESC VARCHAR2(20)
LAST_CHG_USER_ID VARCHAR2(30)
LAST_CHG_DT DATE
The table DMEPOS_BIDDER has primary key (BIDDER_NUM) and 3 foreign keys
(ENT_TYPE_CD, SUPLR_ID, and NTWRK_ID)
When populating data into the table DMEPOS_Bidder, I got the following
error:
Record 1: Rejected - Error on table CBSS.DMEPOS_BIDDER.
ORA-02291: integrity constraint (CBSS.SYS_C007381) violated - parent key
not found...
Can anyone advise why this happens?
Thanks!
syang
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page