error with dblink.
Date: Thu, 05 Feb 2009 17:48:01 +0100
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