Oracle ORA-14074 Create or Add New Partition Fails Error甲骨文庫存- 14074創建或添加新的分區失敗的錯誤

Oracle database partition is a division or decomposition of a logical database and/or its constituting elements (indexes or transaction logs) into distinct, smaller, more manageable and independent parts or pieces. Oracle數據庫分區是一個師或分解一個邏輯數據庫和/或其構成要素（指標或交易日誌）到明顯的，規模較小的，更便於管理和獨立的零部件或成碎片。 Database partitioning provides solution to problems faced by supporting very large tables and indexes, especially in data warehouse applications, which store and analyze large amounts of historical data.數據庫分割的規定，解決所面臨的問題非常大的支持表和指標，特別是在數據倉庫的應用，存儲和分析大量的歷史數據。 With partitioning or table splitting, SQL statements can access and manipulate the partitions rather than entire tables or indexes, and thus increase manageability, performance or availability of the Oracle database.與分割或分裂表， SQL語句可以訪問和操作的分區，而不是整個表或索引，從而提高可管理性，性能或可用性的Oracle數據庫中。

In Oracle Server or Oracle Enterprise Edition, when you want to add an additional new partition to a partitioned table by using the command ALTER TABLE <tablename> ADD PARTITION , the process fails and SQL*Plus will return the following error:在Oracle服務器或Oracle企業版，當您要添加額外的新的分割，以分割表使用命令改變表<tablename>添加分區，過程失敗和SQL *加將返回以下錯誤：

ORA-14074: partition bound must collate higher than that of the last partition庫存- 14074 ：分割的約束，必須整理，高於去年的分割

This error symptom is normally happened when the administrator tries to add or create a new partition to a partitioned table between two partitions, or the new partition is located at the beginning or in the middle of a table, or if the partition bound on the highest partition is MAXVALUE (original partition was created with the highest partition defined as MAXVALUE on the partition key).這個錯誤的症狀通常發生時，管理員嘗試添加或創建新的分區到分區表之間的兩個分區，或新分區位於開始或在中間一張桌子，或如果分區必將對最高分區是maxvalue （即原來的分區創建具有最高的分區定義為maxvalue對分割的關鍵） 。

The most likely case for the error is the MAXVALUE upper bound partition.最有可能的情況下為錯誤是maxvalue上界分割。 You can check if there is such as high value exists in partitions defined for the table by using the following commands in SQL*Plus or TOAD:您可以檢查如果有這樣的作為高價值的存在，在分割界定為表使用下列命令在SQL * Plus或蟾蜍：

select high_value from dba_tab_partitions where table_name = ‘table_name’;選擇high_value從dba_tab_partitions那裡table_name = ' table_name ' ;

You should see something like:您應該會看到一些像這樣：

HIGH_VALUE high_value
——————————————————————————– ---------------------------
10
20
30
MAXVALUE maxvalue

In all of the above scenarios, Oracle doesn’t allow to create a new partition by using Add Partition SQL statement.在所有上述情況下，甲骨文公司是不容許創建新分區使用添加分割SQL語句。 Adding a new partition of these few instances can only be done with a split of partition by using SQL command of SPLIT PARTITION.增添了新的分割這幾個實例，只能做一個分裂的分割使用SQL命令的分裂分割。

So the workaround or solution to the ORA-14074 error is by using the following SQL syntax to achieve the aim to add or create a new partition on an already partitioned table:因此，可行方案或辦法來解決庫存- 14074錯誤是使用下面的SQL語法來達到目的，以添加或創建一個新分區上已經分割表：

ALTER TABLE <tablename> SPLIT PARTITION改變表<tablename>分裂分割

Full syntax will be:充分的語法將是：

ALTER TABLE <table_name> SPLIT PARTITION <partition_name> AT (<value>)改變表<table_name>分裂分割<partition_name> （ <value> ）
INTO (PARTITION <new_partition>, PARTITION <next_partition (or partition_name as above line>)到（ <new_partition>分割，分割<next_partition (or partition_name如上line> ）
UPDATE GLOBAL INDEXES;更新的全球指標;

Note: UPDATE GLOBAL INDEXES is optional.注：更新的全球指標是可選的。

For Example:例如：
ALTER TABLE demo SPLIT PARTITION pmaxvalue at (40) INTO (PARTITION newpartition, PARTITION pmaxvalue);改變表演示分裂分割pmaxvalue在（ 40 ）到（ newpartition分割，分割pmaxvalue ） ;

IMPORTANT : You're reading a machine translated page which is provided "as is" without warranty. 重要說明：您正在閱讀的機器翻譯網頁是“按原樣”提供的擔保。 Unlike human translation, machine translation does not understand the grammar, semantics, syntax, idioms of natural language, thus often produce inaccurate and low quality text which is misleading and incomprehensible.不像人類翻譯，機器翻譯不明白的語法，語義，語法，成語自然語言，因此，往往產生不準確的和低品質的文字，是具誤導性的和難以理解的。 Thus, please refer to因此，請參閱 original English article英文原版的文章 whenever possible.只要有可能。

MDL blog postings now continue at MDL公司博客帖子現在繼續在 Tip and Trick 提示和伎倆 , and readers are welcome to join ，和讀者都歡迎參加 My Digital Life Forums 我的數字生活論壇 . 。

Related Articles相關文章

• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error創建，添加或分裂Oracle數據庫分區失敗，庫存- 14080錯誤
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error甲骨文庫存- 01658無法建立初步的程度，為部分在表錯誤
• ORA-01502 Oracle Index in Unusable State庫存- 01502甲骨文指數在使用的國家
• Oracle Database Import Error 3113/3114 Oracle數據庫的進口錯誤三千一百一十四分之三千一百十三
• ORA-00942 Table or View Does Not Exist Oracle Error庫存- 00942表或視圖不存在Oracle錯誤
• ORA-02449 Oracle Drop Table Error庫存- 02449甲骨文下拉表錯誤
• Manual and Clean Uninstall Oracle for Windows手冊和乾淨的卸載甲骨文為Windows
• Oracle PL/SQL ORA-00947 Not Enough Values Error甲骨文PL / SQL的庫存- 00947沒有足夠的價值觀錯誤
• ORA-25153 Temporary Tablespace is Empty Error in Oracle庫存- 25153臨時表是空的錯誤，在Oracle
• HP “Partiton Overlaps System Recovery Partiton” Error After Deletion惠普“ partiton重疊系統恢復partiton ”的錯誤後刪除

This entry was posted on Wednesday, November 8th, 2006 at 6:04 pm and is filed under 此項目被張貼在週三， 2006年11月8日在下午6時04分，並提交下 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. 從你自己的網站。