标题: ORA-02266: unique/primary keys in table referenced by enabled foreign keys [打印本页] 作者: admin 时间: 2016-7-20 17:30 标题: ORA-02266: unique/primary keys in table referenced by enabled foreign keys ORA-02266: 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 are referencing a table by
issuing the following command: SELECT * FROM USER_CONSTRAINTS WHERE
TABLE_NAME = "tabnam";