aiaiDBA

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

13718043309

010-86462881

ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level

ORA-22997: VARRAY | OPAQUE stored as LOB is not specified at the table level
Cause: An attempt was made to specify a VARRAY|OPAQUE column to be stored as LOB at the partition/subpartition/template level. However the VARRAY|OPAQUE column was not specified to be stored as LOB at the table level when the table was created.
Action: Specify the VARRAY | OPAQUE column to be stored as LOB at the table level when the table is created. Alternatively, do not specify the VARRAY | OPAQUE column to be stored as LOB at the partition/subpartition/template level if it is not specified at the table level when the table is created.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-22997：VARRAY | 未在表级别指定存储为LOB的OPAQUE,
.原因：试图指定要在分区/子分区/模板级别存储为LOB的VARRAY | OPAQUE列。但是，在创建表时，未指定VARRAY | OPAQUE列在表级别存储为LOB。,
.操作：指定VARRAY | OPAQUE列在创建表时在表级别存储为LOB。或者，不要指定VARRAY | OPAQUE列作为LOB存储在分区/子分区/模板级别（如果在创建表时未在表级别指定）。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，704 浏览
  • 慧慧 提出于 2018-08-30 16:45

相似问题