ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

ORA-25017: cannot reference NEW ROWID for movable rows in before triggers
Cause: NEW ROWID was referenced in a before row trigger which is defined on an index-organized table, or a partitioned table with enabled movement of rows. The ROWID cannot be computed in a before row update trigger because it depends on the actual values of the row
Action: Remove references to NEW ROWID from the trigger definition.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:46

ORA-25017：不能引用NEW ROWID在触发前的可移动行,
.原因：在行索引之前引用了NEW ROWID，该行触发器在索引组织的表或启用了行移动的分区表中定义。无法在行更新触发器中计算ROWID，因为它取决于行的实际值,
.操作：从触发器定义中删除对NEW ROWID的引用。,
.

aiaiDBA

13718043309

010-86462881

ORA-25017: cannot reference NEW ROWID for movable rows in before triggers

1 个回答

相似问题