-
ORA-20006: ORA-20001: ORA-08177:can't serialize access for this transcation
Hi
I have Oracle 9i version 9.0.1.1.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.
Regards,
Zeeshan
Regards Zeeshan!
-
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.
Regards Zeeshan!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|