ORA-14085: partitioned table cannot have column with LONG datatype

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

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:42

ORA-14085：分区表不能具有LONG数据类型的列,
.原因：用户尝试创建具有LONG数据类型的分区表或尝试向分区表添加LONG数据类型列。,
.操作：分区表不支持LONG数据类型。创建没有LONG列的表或更改表以便不分区。如果添加列，请不要使用LONG数据类型。如果修改列的属性以将数据类型更改为LONG，则它必须是非分区表。,
.

aiaiDBA

13718043309

010-86462881

ORA-14085: partitioned table cannot have column with LONG datatype

1 个回答

相似问题