aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-14114: partitioned table cannot have column with object, REF, nested table, array datatype

ORA-14114: partitioned table cannot have column with object, REF, nested table, array datatype
Cause: User tried to create a partitioned table with a object datatype (object, REF, nested table, array) or tried to add a object datatype column to a partitioned table.
Action: object data types are not supported with partitioned tables. Create table without object column or change table to not partitioned. If adding column, do not use object datatypes. If modifying attributes of a column to change data type to object, it has to be a non partitioned table.

请先 登录 后评论

1 个回答

小智
ORA-14114:分区表不能具有带有对象,REF,嵌套表,数组数据类型的列,
.原因:用户尝试创建具有对象数据类型(对象,REF,嵌套表,数组)的分区表,或尝试向分区表中添加对象数据类型列。,
.操作:分区表不支持对象数据类型。创建没有对象列的表或更改表以进行分区。如果添加列,请不要使用对象数据类型。如果修改列的属性以将数据类型更改为对象,则它必须是非分区表。,
.
请先 登录 后评论