Distributed transaction already begun
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Distributed transaction already begun

  1. #1
    Join Date
    Jan 2004
    Location
    india
    Posts
    7

    Distributed transaction already begun

    I have created a database link, I got the following error when i am tring to get the data from remote database.

    ORA-02046: distributed transaction already begun
    ORA-02063: preceding line from DB_LINK1.
    Oracle8i Enterprise Edition Release 8.1.7.0.0

    Please help me out.

    Thanks,
    Vijay
    Last edited by vijaymohan; 02-03-2005 at 11:47 PM.
    vijay mohan ch.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the oracle release?

    Tamil

  3. #3
    Join Date
    Jan 2004
    Location
    india
    Posts
    7
    Oracle8i Enterprise Edition Release 8.1.7.0.0
    vijay mohan ch.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Increase the value of distributed_transactions init parameter to 150 and try again.

    If you still get the error, contact Oracle Support.

    Tamil

  5. #5
    Join Date
    Jan 2004
    Location
    india
    Posts
    7
    already the parameter value in init.ora is 500 i had increased it to 600 but there is no change.The error message is still coming.
    vijay mohan ch.

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Issue a commit after the select statement.
    May be this will solve your problem.

    Tamil

  7. #7
    Join Date
    Sep 2008
    Posts
    1
    For everyone else still struggling with this error...
    On 10g I have found a workaround that works for smaller linked tables. The table that was causing the problem was a link to a link on another server. I now create a temp table and copy the whole linked table to the server I am on at the beginning of my proc. Then, instead of the linked table I use the temp table and my proc works.

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