ORA-20006: ORA-20001: ORA-08177:can't serialize access for this transcation
I have Oracle 9i version 18.104.22.168.1.
I have forms and report developed in Developer 6.
When we update or insert record these record are updated in lots of tables so triggers are used.
Some time when when update or insert record this error occurs and it says
ORA-20006: ORA-20001: ORA-08177: can't serialize access for this transaction
ORA-04088: error during execution of trigger
Now we have check our triggers and there is should be no problem in it.
Some one was saying its some kind of bug in Oracle.
Can Any one Plz help!
I am really desperate.
It's not a bug, it's an issue with use of serializable transactions. What it means is that your application attempted to update table values that had changed since the time that the transaction started. Since that would not be a safe operation, the modification fails.
Tom Kyte has an explanation in this thread
Thanx for ur reply
Some body told me to increase INITRANS of the table involved.
Will this work and how can do this.
Also I cannot change the SQL statements because our Developer are quite stubborn they wont allow it.
Any more ideas
Plz I really need help.
Click Here to Expand Forum to Full Width