ORA-22982: cannot create sub-view under this view

ORA-22982: cannot create sub-view under this view
Cause: The view derives its OID from a table/view having primary key based OID and sub-views cannot be created under such views.
Action: Specify view having system generated OID or a view created with the specification of attributes in the WITH OBJECT ID clause and retry the operation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:45

ORA-22982：无法在此视图下创建子视图,
.原因：视图从具有基于主键的OID的表/视图中导出其OID，并且无法在此类视图下创建子视图。,
.操作：指定具有系统生成的OID的视图或使用WITH OBJECT ID子句中的属性规范创建的视图，然后重试操作。,
.

aiaiDBA

13718043309

010-86462881

ORA-22982: cannot create sub-view under this view

1 个回答

相似问题