ORA-12838: cannot read/modify an object after modifying it
in parallel



ORA-12838: cannot read/modify an object after modifying it in parallel..

Answer / guest

Cause: Within the same transaction, an attempt was made to
add read or modification statements on a table after it had
been modified in parallel or with direct load. This is not
permitted.

Action: Rewrite the transaction, or break it up into two
transactions: one containing the initial modification and
the second containing the parallel modification operation.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01664: Transaction which has expanded the Sort Segment has aborted

1 Answers  


ORA-07339: spcre: maximum number of semaphore sets exceeded.

1 Answers  


ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

1 Answers  


RMAN-00601: fatal error in recovery manager

1 Answers  


ORA-19750: change tracking file: 'string'

1 Answers  






LCD-00209: missing value for keyword at end of string [string]

1 Answers  


DRG-10601: failed to remove pending DML for this index

1 Answers  


PLS-00726: MODIFY ELEMENT is supported only on schema-level varray and nested tables

1 Answers  


ORA-24359: OCIDefineObject not invoked for a Object type or Reference

1 Answers  


TNS-04037: Connections refer to string.

1 Answers  


ORA-12926: FORCE LOGGING option already specified

1 Answers  


TNS-00041: INTCTL: Navigator already running. Start operation cancelled

1 Answers  


Categories