ORA-30756: cannot create column or table of type that contains a supertype attribute

ORA-30756: cannot create column or table of type that contains a supertype attribute
Cause: The user tried to create a column or table of an object type that contains a supertype attribute. This is not supported because it leads to infinite recursion in our current storage model. Note that creating a column of a type implies that we create columns corresponding to all subtype attributes as well.
Action: Change the type definition to contain a supertype REF attribute instead of the supertype object attribute.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:49

ORA-30756：无法创建包含超类型属性的类型的列或表,
.原因：用户尝试创建包含超类型属性的对象类型的列或表。这不支持，因为它导致在我们当前的存储模型中的无限递归。请注意，创建类型的列意味着我们也创建对应于所有子类型属性的列。,
.操作：将类型定义更改为包含超类型REF属性，而不是超类型对象属性。,
.

aiaiDBA

13718043309

010-86462881

ORA-30756: cannot create column or table of type that contains a supertype attribute

1 个回答

相似问题