ora-14400: 插入的分区关键字未映射到任何分区 oracle自动分区插入时报ora-14400
\u5173\u4e8eOracle \u5206\u533a\u5b9e\u73b0\u548c\u64cd\u4f5c\u7684\u51e0\u4e2a\u95ee\u98981. \u7ec4\u5408\u5206\u533a\u8868\u7684\u521b\u5efa\u65b9\u5f0f\uff08"\u8303\u56f4-\u54c8\u7a00"\uff09\uff0c\u89c1\u96441
2. \u697c\u4e3b\u7684\u9700\u6c42\uff0c\u5373"\u8303\u56f4-\u8303\u56f4\u5206\u533a"\uff0c\u5728ORACLE 9i, 10g\u7ecf\u8fc7\u6d4b\u8bd5\u90fd\u662f\u4e0d\u80fd\u5b9e\u73b0\u7684
\u5728\u96441\u7684\u57fa\u7840\u4e0a\u4fee\u6539\u4e3a"\u8303\u56f4-\u8303\u56f4"\u7ec4\u5408\u5206\u533a\uff0c\u521b\u5efa\u65f6\u62a5\u9519\uff1aORA-14151\uff1a\u65e0\u6548\u7684\u8868\u5206\u533a\u65b9\u6cd5
3. \u5173\u4e8esxdtgsh\u5144\u7684\u56de\u7b54\uff0c\u6211\u6d4b\u4e86
3.1 \u6ca1\u6709maxvalue\u4e0a\u9650\u5206\u533a\u8bbe\u7f6e\uff0c\u5728\u63d2\u5165\u8d85\u51fa\u5206\u533a\u7684\u6570\u636e\u65f6\u4f1a\u62a5\u9519ORA-14400: \u63d2\u5165\u7684\u5206\u533a\u5173\u952e\u5b57\u672a\u6620\u5c04\u5230\u4efb\u4f55\u5206\u533a
3.2 \u6309\u56de\u7b54\u7684\u8bed\u53e5\u521b\u5efa\u5206\u533a\u8868\u6ca1\u6709\u95ee\u9898\uff0c\u4f46\u6570\u636e\u65e0\u6cd5\u6309\u7167\u697c\u4e3b\u7684\u9700\u6c42\u5206\u5e03
\uff1d\uff1d\uff1d\uff1d\u96441
\u9644\u5f55\uff1a\u521b\u5efa"\u8303\u56f4-\u54c8\u7a00"\u7ec4\u5408\u5206\u533a\u8868
CREATE TABLE TAB11 (ID NUMBER,DT DATE)
PARTITION BY RANGE (DT)
SUBPARTITION BY HASH (ID) SUBPARTITIONS 2 -- \u81ea\u5206\u533a\u4e2a\u6570\uff0c\u53ef\u4ee5\u4e0d\u5199\uff0c\u7531\u7cfb\u7edf\u5224\u65ad
(
PARTITION Y2012 VALUES LESS THAN (TO_DATE('2013-01-01','YYYY-MM-DD'))
(
SUBPARTITION Y2012_H1
,SUBPARTITION Y2012_H2
)
,PARTITION Y2013 VALUES LESS THAN (TO_DATE('2014-01-01','YYYY-MM-DD'))
(
SUBPARTITION Y2013_H1
,SUBPARTITION Y2013_H2
)
,PARTITION YMAX VALUES LESS THAN (MAXVALUE)
(
SUBPARTITION YMAX_H1
,SUBPARTITION YMAX_H2
)
)
\uff1d\uff1d\uff1d\uff1d\u96442\uff0c\u8bf7\u697c\u4e3b\u68c0\u67e5\u6700\u540e\u67e5\u8be2\u7684\u6570\u636e\u5206\u5e03
create table T_TEST
(
ID NUMBER(20) NOT NULL,
TIME DATE NOT NULL
)
partition by range(TIME, ID) -- \u6309\u65f6\u95f4\u3001ID\u8303\u56f4\u5206\u533a \u8fd9\u4e2a\u4f8b\u5b50\u662f\u6309\u5e74\u7684
(
partition P_2012_10 values less than (to_date('2013-01-01','yyyy-MM-dd'), 10),
partition P_2012_20 values less than (to_date('2013-01-01','yyyy-MM-dd'), 20),
partition P_2012_MAX values less than (to_date('2013-01-01','yyyy-MM-dd'), MAXVALUE),
partition P_2013_10 values less than (to_date('2014-01-01','yyyy-MM-dd'), 10),
partition P_2013_20 values less than (to_date('2014-01-01','yyyy-MM-dd'), 20),
partition P_2013_MAX values less than (to_date('2014-01-01','yyyy-MM-dd'), MAXVALUE),
partition P_MAX values less than (MAXVALUE,MAXVALUE)
);
INSERT INTO T_TEST VALUES (1,TO_DATE('20121204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (12,TO_DATE('20121204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (32,TO_DATE('20121204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (2,TO_DATE('20131204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (12,TO_DATE('20131204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (33,TO_DATE('20131204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (3,TO_DATE('20141204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (23,TO_DATE('20141204 00:00:00','YYYYMMDD HH24:MI:SS'));
INSERT INTO T_TEST VALUES (43,TO_DATE('20151204 00:00:00','YYYYMMDD HH24:MI:SS'));
SELECT * FROM T_TEST;
SELECT * FROM T_TEST PARTITION(P_2012_10);
SELECT * FROM T_TEST PARTITION(P_2012_20);
SELECT * FROM T_TEST PARTITION(P_2012_MAX);
SELECT * FROM T_TEST PARTITION(P_2013_10);
SELECT * FROM T_TEST PARTITION(P_2013_20);
SELECT * FROM T_TEST PARTITION(P_2013_MAX);
SELECT * FROM T_TEST PARTITION(P_MAX);
oerr ora 14400
14400, 00000, "inserted partition key does not map to any partition"
// *Cause: An attempt was made to insert a record into, a Range or Composite
// Range object, with a concatenated partition key that is beyond
// the concatenated partition bound list of the last partition -OR-
// An attempt was made to insert a record into a List object with
// a partition key that did not match the literal values specified
// for any of the partitions.
// *Action: Do not insert the key. Or, add a partition capable of accepting
// the key, Or add values matching the key to a partition specification
\u4f60\u7684\u5206\u533a\u5b9a\u4e49\u5f97\u6709\u95ee\u9898\u6216\u63d2\u5165\u7684\u5173\u952e\u5b57\u4e0d\u5bf9\u6240\u81f4\uff0c\u6ca1\u6709\u5efa\u7f3a\u7701\u5206\u533a\u6216\u6700\u5927\u503c\u548c\u6700\u5c0f\u503c\u5b9a\u4e49\u4e0d\u5408\u7406\u3002
Action: Do not insert the key. Or, add a partition capable of accepting the key, Or add values matching the key to a partition specification
扩展阅读：国产液相色谱 ... ora error01031 ... 日本资生堂色谱柱 ... ora-14400 解决办法 ... vcruntime140 1.dll下载 ... oracle-39776 00600 ... 酷睿ultra9和i9哪个好 ... ora-14400怎么解决 ... oracle-14400 ...
