我建立的物化视图
从分区表中取数据再刷新过程中出现如下错误
是什么原因
APT_CombinedOperatorController,0: Fatal Error: Fatal: ORA-12008:
error in materialized view refresh path ORA-14400:
inserted partition key does not map to any partition ORA-06512: at "SYS.DBMS_SNAPSHOT",
line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-065
从分区表中取数据再刷新过程中出现如下错误
是什么原因
APT_CombinedOperatorController,0: Fatal Error: Fatal: ORA-12008:
error in materialized view refresh path ORA-14400:
inserted partition key does not map to any partition ORA-06512: at "SYS.DBMS_SNAPSHOT",
line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-065
error in materialized view refresh path ORA-14400:
inserted partition key does not map to any partition ORA-06512: at "SYS.DBMS_SNAPSHOT",
line 820 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 877 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 858 ORA-065
上面已经错误描述得很清楚了,插入分区表中的分区键值不在表分区的范围内
可以检查一下要插入的数据的分区键字段值是什么,
被插入表分区范围如果没有包含的话,增加相应的分区。
插入分区表的值不在分区列表中,建议建分区表的时候,最好都在最后面加一个默认分区。
PARTITION pdefault VALUES (default) TABLESPACE 分区表名;