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

From Robs_Wiki
Revision as of 14:18, 6 February 2020 by Qadmin wiki (talk | contribs) (Error Explanation)
Jump to: navigation, search

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