ORA-22857: cannot modify columns of object tables

ORA-22857: cannot modify columns of object tables
Cause: An attempt was made to alter the object table by modifing existing columns. An object table cannot be altered to modify existing columns since it is based on an object type. The table definition must be in sync with the corresponding type.
Action: Create a new type with the desired attribute types and use it to create an object table. The new object table will have the desired columns.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-22857：无法修改对象表的列,
.原因：尝试通过修改现有列来更改对象表。不能更改对象表以修改现有列，因为它基于对象类型。表定义必须与相应类型同步。,
.操作：使用所需的属性类型创建一个新类型，并使用它来创建一个对象表。新对象表将具有所需的列。,
.

aiaiDBA

13718043309

010-86462881

ORA-22857: cannot modify columns of object tables

1 个回答

相似问题