Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

ArunnathJul 28 2015 — edited Jul 28 2015

Hi All,

I am getting this error while inserting records into a table after setting TRANSACTION ISOLATION LEVEL SERIALIZABLE.

The table is having a primary_key. The insert is working fine when I removed primary_key.

But insert for other tables with primary key is working fine with this option. There is no update happening in source while inserting.

Please help me to resolve this issue.

Regards

Arunnath

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2015
Added on Jul 28 2015
7 comments
4,813 views