ORA-02449 Oracle Drop Table Error库存- 02449甲骨文下拉表错误

Sometimes when dropping a table in Oracle database by executing DROP TABLE SQL statement, Oracle may return the error ORA-02449 as below:有时，当下降的一个表中Oracle数据库的执行下拉表的SQL语句，甲骨文可能会返回错误库存- 02449如下：

ORA-02449: unique/primary keys in table referenced by foreign keys库存- 02449 ：独特/主键在表中所引用的外键

The Oracle error is caused by the attempt to drop a table with unique or primary keys referenced by foreign keys in another table, or in other word, the table that is referenced as a parent table by a foreign key constraint in a parent-child relationship that established between two tables through a foreign key.甲骨文是错误所造成的企图下拉表与独特性或主键所引用的外键在另一桌上，或在其他字，该表是参照作为一个父表由一家外国的关键制约因素，在亲子关系这之间建立了两个表通过外键。 Oracle does not allow to drop tables referenced by foreign keys of other tables without specifying the CASCADE CONSTRAINTS option in the DROP TABLE statement, or to drop the parent table without first removing the foreign key.甲骨文公司是不容许下降表所引用的外键的其他表没有具体的限制，级联选项，在下拉表的声明，或下降父表没有先删除外键。

The solution and workaround for the error when you want to drop tables referenced by child tables, is to use the CASCADE CONSTRAINTS option in the DROP TABLE statement.该解决方案和可行的错误时，您要下拉表所引用的儿童表，是使用级联的限制，选择在下拉表的声明。 For example:例如：

DROP TABLE table_name CASCADE CONSTRAINTS;下拉表table_name级联的限制;

The CASCADE CONSTRAINTS option in the DROP TABLE SQL statement will drop the FOREIGN KEY constraints of the child tables referenced.级联的限制，选择在下拉表的SQL语句将下降外交的主要制约因素的儿童表引用。

Alternatively, you can manually drop and remove the foreign key key constraints in other tables before performing the DROP TABLE operations on the parent table, drop the foreign key constraints in other tables.另外，您也可以手动下降，并删除外键的主要制约因素，在其他表前表演的下拉表操作对父表，下拉外国的主要制约因素，在其他表。 To check what constraints are referencing a table in Oracle, use the following command:要检查什么限制，是参照表在Oracle中，使用下列命令：

SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = “ table_name “;选择*从user_constraints那里table_name = “ table_name ” ;

To drop and delete the user constraints in Oracle use the following command in SQL*Plus, Toad or other SQL tools:下降，并删除用户的限制，在Oracle使用下列命令在SQL *加，蟾蜍或其他SQL Server工具：

ALTER TABLE table_name DROP CONSTRAINT constraint_name ;改变表table_name下拉约束constraint_name ;

IMPORTANT : This is a machine translated page which is provided "as is" without warranty. 重要说明 ：这是一个机器翻译网页是“按原样”提供的担保。 Machine translation may be difficult to understand.机器翻译可能很难理解。 Please refer to请参阅 original English article原来的英语文章 whenever possible.只要有可能。

Share and contribute or get technical support and help at分享和贡献，或取得技术的支持和帮助，在 My Digital Life Forums 我的数字生活论坛 . 。

Related Articles相关文章

• ORA-00942 Table or View Does Not Exist Oracle Error库存- 00942表或视图不存在Oracle错误
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error创建，添加或分裂Oracle数据库分区失败，库存- 14080错误
• Oracle Database Import Error 3113/3114 Oracle数据库的进口错误三千一百一十四分之三千一百十三
• Oracle ORA-14074 Create or Add New Partition Fails Error甲骨文库存- 14074创建或添加新的分区失败的错误
• ORA-01502 Oracle Index in Unusable State库存- 01502甲骨文指数在使用的国家
• Oracle PL/SQL ORA-00947 Not Enough Values Error甲骨文PL / SQL的库存- 00947没有足够的价值观错误
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error甲骨文库存- 01658无法建立初步的程度，为部分在表错误
• ORA-25153 Temporary Tablespace is Empty Error in Oracle库存- 25153临时表是空的错误，在Oracle
• Manual and Clean Uninstall Oracle for Windows手册和干净的卸载甲骨文为Windows
• Oracle EXP-00091 Error When Export Database甲骨文进出口- 00091时发生错误，进出口数据库

This entry was posted on Wednesday, August 23rd, 2006 at 5:35 pm and is filed under 此项目被张贴在周三， 2006年8月23日在下午5时35分，并提交下 Databases 数据库 . 。 You can follow any responses to this entry through the 您可以按照任何的反应，此项目通过 RSS 2.0 2.0 feed. 喂养。 You can 您可以 leave a response 留下的回应 , or ，或 trackback Trackback跟踪 from your own site. 从你自己的网站。