ORA-02266: 表中的唯一/主键被启用的外键引用

最新推荐文章于 2025-01-07 11:59:30 发布

转载最新推荐文章于 2025-01-07 11:59:30 发布 · 136 阅读

TRUNCATE TABLE "B2BADMIN"."BIZDOC" DROP STORAGE
Error at line 2
ORA-02266: 表中的唯一/主键被启用的外键引用

这个时候可以diable 对应的FK ，删除数据后，再enable 起来。

select * from ALL_CONSTRAINTS
WHERE constraint_type='R' and wner='B2BADMIN'
AND R_CONSTRAINT_NAME = 'PK_BIZDOC_DOCID';

alter table B2BADMIN.BIZDOCARRAYATTRIBUTE disable constraint FK_BDARRATT_DOCID_BIZDOC;
alter table B2BADMIN.BIZDOCRELATIONSHIP disable constraint FK_BIZDOCREL_DOCID_BIZDOC;
alter table B2BADMIN.BIZDOCRELATIONSHIP disable constraint FK_BIZDOCREL_RELATDOCID_BIZDOC;
alter table B2BADMIN.BIZDOCATTRIBUTE disable constraint FK_BIZDOCATT_DOCID_BIZDOC ;
alter table B2BADMIN.BIZDOCCONTENT disable constraint FK_BIZDOCCONT_DOCID_BIZDOC ;
alter table B2BADMIN.DELIVERYJOB disable constraint FK_DELIJOB_DOCID_BIZDOC ;
alter table B2BADMIN.ACTIVITYLOG disable constraint FK_ACTLOG_RELATEDDOCID_BIZDOC ;

truncate table bizdoc .

alter table B2BADMIN.BIZDOCARRAYATTRIBUTE enable constraint FK_BDARRATT_DOCID_BIZDOC;
alter table B2BADMIN.BIZDOCRELATIONSHIP enable constraint FK_BIZDOCREL_DOCID_BIZDOC;
alter table B2BADMIN.BIZDOCRELATIONSHIP enable constraint FK_BIZDOCREL_RELATDOCID_BIZDOC;
alter table B2BADMIN.BIZDOCATTRIBUTE enable constraint FK_BIZDOCATT_DOCID_BIZDOC ;
alter table B2BADMIN.BIZDOCCONTENT enable constraint FK_BIZDOCCONT_DOCID_BIZDOC ;
alter table B2BADMIN.DELIVERYJOB enable constraint FK_DELIJOB_DOCID_BIZDOC ;
alter table B2BADMIN.ACTIVITYLOG enable constraint FK_ACTLOG_RELATEDDOCID_BIZDOC ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-660824/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-660824/