oracle中 keys,案例:Oracle报错ORA-02266:unique/primary keys in table ....foreign keys

天萃荷净开发DBA反映在执行truncate清空一张表记录发现ORA-02266,进行模拟测试分析原因为存在主外键或索引导致1.truncate清空表报ORA-02266错误SQL> truncate table p;truncate table p*ERROR at line 1:ORA-02266: unique/primary keys in table referenced by e...
摘要由CSDN通过智能技术生成

天萃荷净

开发DBA反映在执行truncate清空一张表记录发现ORA-02266,进行模拟测试分析原因为存在主外键或索引导致

1.truncate清空表报ORA-02266错误

SQL> truncate table p;

truncate table p

*

ERROR at line 1:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys

--错误原因

SQL> !oerr ora 02266

02266, 00000, "unique/primary keys in table referenced by enabled foreign keys"

// *Cause: An attempt was made to truncate a table with unique or

//         primary keys referenced by foreign keys enabled in another table.

//         Other operations not allowed are dropping/truncating a partition of a

//         partitioned table or an ALTER TABLE EXCHANGE PARTITION.

// *Action: Before performing the above operations the table, disable the

//          foreign key constraints in other tables. You can see what

//          constraints

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值