CREATE TABLE BUSI_FLUX_STAT_T
(
PERIOD VARCHAR2(9 BYTE) NOT NULL,
BUSI_ID NUMBER(38) NOT NULL,
STOREFRONT_ID NUMBER(38) NOT NULL,
MSG_UP NUMBER(10),
MSG_DOWN NUMBER(10),
CREATE_TIME DATE
)ALTER TABLE BUSI_FLUX_STAT_T ADD (
PRIMARY KEY (PERIOD, BUSI_ID, STOREFRONT_ID));ALTER TABLE BUSI_FLUX_STAT_T ADD (
FOREIGN KEY (STOREFRONT_ID)
REFERENCES STOREFRONT_T (STOREFRONT_ID));ALTER TABLE BUSI_FLUX_STAT_T ADD (
FOREIGN KEY (BUSI_ID)
REFERENCES BUSINESS_T (BUSI_ID));
这是建表的数据可是用insert 插入这是出现ORA-02291: 违反完整约束条件 (IISPR.SYS_C003750) - 未找到父项关键字异常请各位帮忙
(
PERIOD VARCHAR2(9 BYTE) NOT NULL,
BUSI_ID NUMBER(38) NOT NULL,
STOREFRONT_ID NUMBER(38) NOT NULL,
MSG_UP NUMBER(10),
MSG_DOWN NUMBER(10),
CREATE_TIME DATE
)ALTER TABLE BUSI_FLUX_STAT_T ADD (
PRIMARY KEY (PERIOD, BUSI_ID, STOREFRONT_ID));ALTER TABLE BUSI_FLUX_STAT_T ADD (
FOREIGN KEY (STOREFRONT_ID)
REFERENCES STOREFRONT_T (STOREFRONT_ID));ALTER TABLE BUSI_FLUX_STAT_T ADD (
FOREIGN KEY (BUSI_ID)
REFERENCES BUSINESS_T (BUSI_ID));
这是建表的数据可是用insert 插入这是出现ORA-02291: 违反完整约束条件 (IISPR.SYS_C003750) - 未找到父项关键字异常请各位帮忙
比如:
BUSINESS_T 中 没有 BUSI_ID 为 aa 的
而你在 BUSI_FLUX_STAT_T 插入 BUSI_ID 为 aa 那就会出现 违反完整约束条件 (IISPR.SYS_C003750)
a refernce b
b refernce c
c refernce a
这样的环?
a要插入有参看b
b又参看c
c又参看a
这样没完没了地参照,肯定不行。
断开插入,你试试看!