ORA-25001: cannot create this trigger type on this type of view

ORA-25001: cannot create this trigger type on this type of view
Cause: INSTEAD OF triggers can be created on any view which is not an Editioning View, while BEFORE and AFTER triggers may only be created on Editioning Views.
Action: Change the trigger type to INSTEAD OF or change the view on which you are attempting to create a DML trigger.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:46

ORA-25001：无法在此类型的视图上创建此触发器类型,
.原因： INSTEAD OF触发器可以在非版本视图的任何视图上创建，而BEFORE和AFTER触发器只能在编辑视图上创建。,
.操作：将触发器类型更改为INSTEAD OF或更改您尝试创建DML触发器的视图。,
.

aiaiDBA

13718043309

010-86462881

ORA-25001: cannot create this trigger type on this type of view

1 个回答

相似问题