Oracle DB Error ORA-25017 cannot reference NEW ROWID for movable rows in before triggers

The following is the cause of this error:

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 you can take to resolve this issue: Remove references to NEW ROWID from the trigger definition.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related