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

From Robs_Wiki
Jump to: navigation, search
(Error Explanation)
(Error Explanation)
Line 15: Line 15:
  
 
•cause: The problem manifest itself when there are indexes on the 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     
+
to which the rows are being inserted.  Without any indexes the problem will not reproduce     
 
</pre>
 
</pre>
  
 
== Reproduce the error ==
 
== Reproduce the error ==

Revision as of 14:18, 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