Re: Bug in the databases links ? URGENT !

Try,

alter session close database link DBLINK_NAME;

This will remove the lock.

Tarkus <IPS_at_Wanadoo.fr> wrote in article <34702608.67D0_at_Wanadoo.fr>... 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édéric JUGE
Tarkus_at_Wanadoo.fr
"There's nothing to try, you do it, or you don't" Yoda.

----------