PLS-00719: only widening of attribute 'string' constraints is allowed

PLS-00719: only widening of attribute 'string' constraints is allowed
Cause: Modification to the attribute did not widen its constraints or attempted to change the type of the attribute. For NUMBER type attributes, scale and precision can be changed to allow increase in number of digits after and before the decimal point. For VARCHAR2 and RAW type attributes the size can be increased. Other type attributes are not allowed to be modified. Change of type of attribute is also not allowed.
Action: Change the constraint specification so as to widen the existing constraints.To narrow the constraints or to change the type of the attribute, you must drop the attribute and add it with new constraints or new type. In that case you must also take appropriate steps to preserve your existing data based on the type (if you want to preserve it).Typically this will involve backing up the data and restoring it after the ALTER TYPE.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00719：只允许扩展属性' string '约束,
.原因：修改属性没有扩大其约束或尝试更改属性的类型。对于NUMBER类型属性，可以更改比例和精度，以允许增加小数点后的位数。对于VARCHAR2和RAW类型属性，可以增加大小。其他类型属性不允许修改。也不允许更改属性类型。,
.操作：更改约束规范以扩大现有约束。要缩小约束或更改属性的类型，必须删除该属性并添加新的约束或新类型。在这种情况下，您还必须采取适当的步骤，根据类型保留现有数据（如果要保留）。通常这将包括备份数据并在ALTER TYPE之后进行恢复。,
.

aiaiDBA

13718043309

010-86462881

PLS-00719: only widening of attribute 'string' constraints is allowed

1 个回答

相似问题