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-29929: missing SCAN Keyword

1 Answers  


ORA-13137: failed to generate tablespace sequence number

1 Answers  


ORA-39311: illegal clone_recovery() call: it only applys to failed clones

1 Answers  


CLSS-00003: unable to determine cluster name. type string

1 Answers  


ORA-01370: Specified restart SCN is too old

1 Answers  






NNL-00201: Shutdown occurs in string

1 Answers  


ORA-01572: rollback segment 'string' cannot be brought online, string extents exceeded

1 Answers  


IMP-00084: attempt to mix incremental import with user or table import

1 Answers  


ORA-28593: agent control utility: command terminated with error

1 Answers  


ORA-28178: password not provided by proxy

1 Answers  


ORA-01685: max # extents (string) reached in index string.string partition string

1 Answers  


ORA-26530: unable to build materialized view refresh control list

1 Answers  


Categories