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

TNS-04205: Trace Assistant Internal ERROR: Memory

1 Answers  


ORA-12690: Server Authentication failed, login cancelled

1 Answers  


RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers  


ORA-01575: timeout waiting for space management resource

1 Answers  


EXP-00024: Export views not installed, please notify your DBA

1 Answers  


DRG-12607: only ctxsys can create MULTI_COLUMN preferences

1 Answers  


NNL-00544: Displays operations statistics

1 Answers  


ORA-27504: IPC error creating OSD context

1 Answers  


ORA-40201: invalid input parameter string

1 Answers  


ORA-25406: could not generate a connect address

1 Answers  


ORA-38756: Flashback is already turned off for this tablespace.

1 Answers  


ORA-25245: agent name cannot be specified if address is a single-consumer queue or an exception queue

1 Answers  


Categories