-
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.
-
What is the oracle release?
Tamil
-
Oracle8i Enterprise Edition Release 8.1.7.0.0
vijay mohan ch.
-
Increase the value of distributed_transactions init parameter to 150 and try again.
If you still get the error, contact Oracle Support.
Tamil
-
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.
-
Issue a commit after the select statement.
May be this will solve your problem.
Tamil
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|