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

ORA-30725: JDWP-based debugging is not yet available

1 Answers  


ORA-08431: raw data missing zero as defined in picture

1 Answers  


ORA-02164: DATAFILE clause specified more than once

1 Answers  


DGM-16952: unable to describe configuration

1 Answers  


ORA-15132: block string of file string in diskgroup string could not be written

1 Answers  






NNO-00262: warning: cannot write checkpoint file "string"

1 Answers  


NZE-28786: decryption of encrypted private key failure

1 Answers  


NNL-00037: Error number while sequencing through parameter table.

1 Answers  


ORA-32550: Replacement occured despite hint to the contrary

1 Answers  


ORA-39076: cannot delete job string for user string

1 Answers  


ORA-01560: LIKE pattern contains partial or illegal character

2 Answers  


ORA-32159: Cannot set prefetch options for a null Type

1 Answers  


Categories