DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003

    ORA-20006: ORA-20001: ORA-08177:can't serialize access for this transcation

    I have Oracle 9i version
    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!

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    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
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Mar 2003
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.