how to solve this problem?ORA-02270

Question

问题应该在ALL_OBJECT_TBL，你运行下面SQL后再看看。
alter table all_object_table add constraint all_object_tbl_pk primary key
(BUILDING_ID,POINT_ID,DEVICE_IDENTIFIER)

Answer 1

问题在于下面这句没找到相应的主键或唯一键，
CONSTRAINT AP_IDENTIFIER_TBL_FK_1 FOREIGN KEY(BUILDING_ID,POINT_ID,DEVICE_IDENTIFIER) REFERENCES ALL_OBJECT_TBL(BUILDING_ID,POINT_ID,DEVICE_IDENTIFIER) ON DELETE CASCADE
你最好在 ALL_OBJECT_TBL 表上手工建立一个唯一约束：
alter table all_object_table add constraint all_object_tbl_pk unique key
(BUILDING_ID,POINT_ID,DEVICE_IDENTIFIER)