重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-02449: unique/primary keys in table referenced by foreign keys [打印本页]

作者: admin 时间: 2016-7-22 10:55
标题: ORA-02449: unique/primary keys in table referenced by foreign keys

ORA-02449: unique/primary keys in table referenced byforeign keys

Cause: An attempt was made to drop a table with unique orprimary keys

referenced by foreign keys in another table.

Action: Before performing the above operations the table, dropthe foreign key

constraints in other tables. You can see what constraints are referencinga table by

issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE

TABLE_NAME = "tabnam";

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)