ORA-20006: ORA-20001: ORA-08177:can't serialize access for this transcation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Mar 2003
    Posts
    32

    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!

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    Posts
    32
    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