How to fix the Oracle error ORA-25017: cannot reference NEW ROWID for movable rows in before triggers?

In this post, you’ll learn more about the Oracle ErrorORA-25017: cannot reference NEW ROWID for movable rows in before triggers with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-25017: cannot reference NEW ROWID for movable rows in before triggers ?

You can fix this error in Oracle by following the below steps

Remove references to NEW ROWID from the trigger definition.