工作中遇到了一个小问题。
在truncate一个表时出现了报错:ORA-02266: 表中的唯一/主键被启用的外键引用
查找到该表的主键被另外一个表的外键引用了。
将外键删除后可以正常truncate表。
将该外键再次启用后,无论主表还是从表是否有数据,都不能对主表进行truncate操作。
看来以后做迁移前还需要将这些外键禁用掉,不仅能够提高效率,还可以避免类似的麻烦。
tom给出的原因是:
because Oracle does not permit that DDL to take place, with data integrity constraints, you have to delete - or
a) disable foreign key
b) truncate
c) enable foreign key (pretty darn fast, nothing to check obviously)
the table might appear empty to you (the child table) but that doesn't mean it is empty - other transactions could have stuff being inserted in there that you just cannot see yet.
参考:
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1192635578609
http://www.itpub.net/thread-872721-1-1.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26451536/viewspace-754261/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26451536/viewspace-754261/