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

From Robs_Wiki
Jump to: navigation, search
(Created page with "__TOC__ == Reference == My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1) == Error Explanation == == Reproduce the error ==")
 
(Error Explanation)
Line 3: Line 3:
 
My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1)
 
My Oracle Support Note : Insert Into Table Fails With ORA-08177 (Doc ID 160593.1)
 
== Error Explanation ==
 
== Error Explanation ==
 +
<pre>
 +
•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   
 +
</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