Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

RMAN-08019: channel string: restoring datafile string

1 Answers  


ORA-13800: concurrent DDL failure on SQL repository objects

1 Answers  


ORA-14167: only one subpartition may be moved

1 Answers  


NID-00336: The following datafiles are offline clean:

1 Answers  


NNL-00953: Cache lookup exact matches: number

1 Answers  






ORA-01351: tablespace given for Logminer dictionary does not exist

1 Answers  


ORA-12434: invalid audit type: string

1 Answers  


TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC

1 Answers  


ORA-31153: Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"

1 Answers  


QSM-01044: join back attempted on a view for string

1 Answers  


ORA-31023: Index size error

1 Answers  


ORA-30333: dimension does not exist

1 Answers  






Categories