Difference between revisions of "ORA-08177: can't serialize access for this transaction"

From Robs_Wiki
Jump to: navigation, search
(Error Explanation)
(Reproduce the error)
Line 19: Line 19:
  
 
== Reproduce the error ==
 
== Reproduce the error ==
 +
In two separate SQL sessions enter the following commands, i.e. type each individual command on one session followed immediately on the other session.
 +
 +
<pre>
 +
</pre>

Revision as of 14:21, 6 February 2020

Reference

My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1)

Error Explanation

•symptom: Insert into table fails

•symptom: ORA-08177: can't serialize access for this transaction

•symptom: transaction isolation level is serializable

•symptom: The table has index definitions

•symptom: Several transaction insert data into same table

•cause: The problem manifest itself when there are indexes on the table   
 to which the rows are being inserted.  Without any indexes the problem will not reproduce     

Reproduce the error

In two separate SQL sessions enter the following commands, i.e. type each individual command on one session followed immediately on the other session.