ORA-42300: an Editioning view is already defined on this table

ORA-42300: an Editioning view is already defined on this table
Cause: An attempt was made to create an Editioning view on a table on which another Editioning view is already defined in the same Edition. This violates a restriction that at most one Editioning view may be associated with any base table in a given Edition.
Action: Create the new view as a regular view or, if the view being created is really intended to be an Editioning view associated with this table, drop the existing Editioning view before creating the new one.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:53

ORA-42300：此表上已定义了版本视图,
.原因：试图在已经在同一版本中定义了另一个编辑视图的表上创建一个编辑视图。这违反了一个限制，最多一个版本视图可能与给定版本中的任何基表相关联。,
.操作：将新视图创建为常规视图，或者如果正在创建的视图确实是与此表关联的“版本”视图，请先删除现有的编辑视图，然后再创建新视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-42300: an Editioning view is already defined on this table

1 个回答

相似问题