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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02107: You may not specify PARSE = FULL when CODE = CPP

1 Answers  


ORA-24305: bad bind or define context

1 Answers  


PCC-00090: Precision/scale specification must be given for DECIMAL datatype

1 Answers  


ORA-16578: failed to read Data Guard configuration file

1 Answers  


ORA-26051: internal error parsing packed decimal format string

1 Answers  


ORA-16166: LGWR network server failed to send remote message

1 Answers  


ORA-12169: TNS:Net service name given as connect identifier is too long

1 Answers   Reliance, Satyam,


ORA-03284: datafile string is not a member of tablespace string

1 Answers  


ORA-13634: The task string needs to be reset before being re-executed.

1 Answers  


DRG-10834: upper-case form of section name string too long

1 Answers  


ORA-06441: ssvwatev: Incorrect parameter passed to function call

1 Answers  


ORA-07616: $CHANGE_CLASS failed in retrieving the specified device label

1 Answers  


Categories