ITPub博客

首页 > Linux操作系统 > Linux操作系统 > truncate table时发生ORA-02266错误[转]

truncate table时发生ORA-02266错误[转]

原创 Linux操作系统 作者:47328983 时间:2011-04-09 13:14:25 0 删除 编辑

10:07:26 SQL> conn utcore/ossI

Connected.

10:07:44 SQL> truncate table mapevent;
truncate table mapevent
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

10:09:53 SQL> !oerr ora 2266
)P002266, 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
// 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
a6S0// constraints are referencing a table by issuing the following
// SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";

10:07:48 SQL> alter table mapevent disable primary key cascade;

Table altered.

10:07:52 SQL> truncate table mapevent;

Table truncated.

10:07:57 SQL> alter table mapevent enable primary key;

Table altered.


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

请登录后发表评论 登录
全部评论

注册时间:2009-03-07

  • 博文量
    111
  • 访问量
    333225