ora 14400

来源:互联网 发布:电视机电视直播软件 编辑:程序博客网 时间:2024/06/05 23:43
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

导入的记录在表中没有对应的分区,解决:
alter table  table1 add partition p_max values less then  (maxvalue);
0 0
原创粉丝点击