重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace [打印本页]

作者: michaeljet 时间: 2016-9-7 09:34
标题: ORA-37107: (XSVPART07) Attempt to write to non-existent partition of workspace

ORA-37107: (XSVPART07) Attempt to write tonon-existent partition of workspace

object.

Cause: Some action attempted to writedata to a partitioned variable, but the

variable didn't have a partition for that data. This canresult from a partition

template that does not assign all possible dimensionvalues to some subcube, or

from a partitioned variable that does not have apartition for one of the partitions

defined by the partition template.

Action: Make sure that the cell beingwritten is assigned to some partition by the

partition template, and that the variable has an actualpartition associated with the

partition of the template. Use the CHGDFN templateDEFINE... command to

define new partitions within the template, and the CHGDFNvariable ADD...

command to add new partitions to the variable.Alternatively, the

PARTWRITEERR can be set to false, in which case databeing written to a

non-existent partition will be silently discarded.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)