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-36640: (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.

1 Answers  


ORA-19507: failed to retrieve sequential file, handle="string", parms="string"

1 Answers  


CLSS-03200: timed out waiting on nested reconfiguration

1 Answers  


ORA-26693: STREAMS string process dropped successfully, but error occurred while dropping rule set string

1 Answers  


ORA-14052: partition-extended table name syntax is disallowed in this context

1 Answers  






PLS-00583: size must be specified if opaque type is fixed-length

1 Answers  


ORA-06766: TLI Driver: close failed during release

1 Answers  


ORA-09812: Unable to get user clearance from connection

1 Answers  


ORA-39313: illegal clone() call: clone has been done before

1 Answers  


ORA-12206: TNS:received a TNS error during navigation

1 Answers  


ORA-28553: pass-through SQL: invalid bind-variable position

1 Answers  


RMAN-20033: controlfile sequence# too low

1 Answers  


Categories