Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error創建，添加或分裂Oracle數據庫分區失敗，庫存- 14080錯誤
Oracle table partitioning is important for optimum performance of the database, as it allows Oracle to process the specific and independat partition or part that is smaller in size, instead of entire full table or database.甲骨文表分割是很重要的最佳性能的數據庫，因為它使得甲骨文的過程中的具體和independat分割或部分是在規模較小的尺寸，而不是整個充分表或數據庫。 However, when you want to create a new partition to a table by adding or splitting partition, administrator may encounter errors such as然而，當你想創建一個新的分區表中加入或分裂，分割，管理員可能會遇到錯誤，如 ORA-14074庫存- 14074 . 。 Other than that, Oracle error ORA-14080 can also happen, if you’re not careful enough with the following symptom:以外， Oracle錯誤庫存- 14080 ，也有可能發生，如果您不小心足夠的具有下列症狀：
ORA-14080: partition cannot be split along the specified high bound庫存- 14080 ：分割，不能分裂，沿著指定的高約束
The cause for ORA-14080 error is due to Oracle user attempted to split a partition along a bound which either collates higher than that of the partition to be split or lower than that of a partition immediately preceding the one to be split.原因庫存- 14080錯誤是由於甲骨文的用戶，企圖分裂一個分區沿約束，任何一方整理高於該分區被分拆或低於一個分區，立即前一要分裂。 In other word, the value that is been specified to split between the partition is incorrect, and part or all of the range of the partition values has been assigned or located in an existing partition defined in the database.在其他一句話，價值是被指定的分裂之間的分割是不正確，和部分或全部的範圍分區的價值觀已指派或設在現有分區的定義在數據庫中。
To solve the problem, the solution or workaround will be to ensure that the bound along which a partition is to be split collates lower than that of the partition to be split and higher that that of a partition immediately preceding the one to be split.為了解決這個問題，解決方案或替代方法將是確保約束沿一個分區是要分裂整理低於該分區被分拆，和更高的那一個分區，立即前一要分裂。 The partition wants to be added or split must has value that are less than its closest higher value partition, yet has value that higher than the upper limit for its closest lower value partition.分區要加入或分裂，必須有值小於其最接近的更高價值的分割，但已值高於上限，其最接近的較低的價值分割。
For example, 3 partitions existed with high value as below:舉例來說，三分區的存在與高價值如下：
Partition Name High Value分區名稱價值高
————– ———- -- -- --
p1 20小一20
p2 40 P2的40
p3 60 P3的60
If you want to add a new partition by splitting with p3 partition, you cannot specify the value of 70 or 30, as both are out of bound.如果您要添加一個新分區由分裂與P3的分區，您不能指定的價值70或30的，因為都是出於約束。 Specify 30 if you want to split the partition of p3.指定30如果你想分裂分割P3的。 For 70, you have to simply create or add new partition in alter table SQL statement command. 70 ，你必須簡便地創建或添加新分區在改變表的SQL語句命令。
Oracle database administrator can use the following command to retrieve a chart like above to help determine the possible wrong value that cause the error: Oracle數據庫管理員可以使用下面的命令來擷取了一份圖表，像上述以幫助確定可能的錯誤值導致錯誤：
SELECT partition_name, high_value選擇partition_name ， high_value
FROM dba_tab_partitions從dba_tab_partitions
WHERE table_name = ‘table_name’凡table_name = ' table_name '
ORDER BY partition_name為了由partition_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相關文章
- Oracle ORA-14074 Create or Add New Partition Fails Error甲骨文庫存- 14074創建或添加新的分區失敗的錯誤
- Oracle Database Import Error 3113/3114 Oracle數據庫的進口錯誤三千一百一十四分之三千一百十三
- Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error甲骨文庫存- 01658無法建立初步的程度，為部分在表錯誤
- ORA-01502 Oracle Index in Unusable State庫存- 01502甲骨文指數在使用的國家
- Oracle Database Link Oracle數據庫的連接
- ORA-00942 Table or View Does Not Exist Oracle Error庫存- 00942表或視圖不存在Oracle錯誤
- ORA-02449 Oracle Drop Table Error庫存- 02449甲骨文下拉表錯誤
- How to Rename or Move Oracle Tablespace Datafile to Another Location如何重新命名或移動甲骨文表datafile到另一個位置
- ORA-25153 Temporary Tablespace is Empty Error in Oracle庫存- 25153臨時表是空的錯誤，在Oracle
- View and Retrieve Oracle Database Link Details查看和檢索Oracle數據庫的連接細節
