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. 從你自己的網站。