Bug in the databases links ? URGENT !

Hi,

I have 8 sites with Oracle Workgroup 7.1 Each site READS remote datas on the 7 other sites. The request is like :

insert as select * from sales_at_xxx =

I have upgraded one of my site to Oracle 7.3. When a site in 7.1 reads a table located on a remote 7.1 database, there is no problem. When this site reads a table located on the remote 7.3 database, there's also no problem.

But AFTER reading the remote 7.3 database, it's impossible to read a remote 7.1 database. It seems that the db-link is not refreshed (!). =

When I execute a request like :

Select * from sales_at_xxx =

where xxx is a database link to a remote 7.1 database, the request returns the table sales of the database yyy which is the remote 7.3 database. If I enter 'commit' (unnecessary because I'm just reading), the problem seems to be solved, just for the next request.

What is this database link confusion ?
I'm in the dark and I can get no explication from Oracle France. Thank you for your help.

• =

Fr=E9d=E9ric JUGE
Tarkus_at_Wanadoo.fr
"There's nothing to try, you do it, or you don't" Yoda. Received on Mon Nov 17 1997 - 00:00:00 CST