error with dblink.

From: Faivre Dominique <faivred_at_ecp.fr>
Date: Thu, 05 Feb 2009 17:48:01 +0100
Message-ID: <gmf5dv$1ie$1_at_guepard.ecp.fr>



I need to access a oracle serveur in 8.0.6 from a client 10g. As I got the error "ORA-03134: Connections to this server version are no longer supported." someone told me to create a dblink on a 8.1.7 server. (in fact I had tested that from the client 10g to 8.1.7 it was ok and from a 8.1.7 to the serveur 8.0.6 it was also ok ) .So I created the dblink .
But when I run a "select" on a table from the 8.0.6 on the 10g client with connection to the 8.1.7 where I have the dblink , I got the following error :

ERROR at line 1:
ORA-02042: too many distributed transactions

I have verified the parameters on the 8.1.7 server I have distributed_transactions=0 and on the 8.0.6, I have "5" .

What must I do ? I don't understand what is the link beetween the dblink and this parameter ? .Thanks in advance for help. Regards

-- 
Faivre Dominique        Administrateur systeme

  « La décroissance ne propose pas de vivre moins, mais mieux avec moins 
de biens et plus de liens. » (Charte de la décroissance)
Received on Thu Feb 05 2009 - 10:48:01 CST

Original text of this message