A few months ago I set up a connection so that from Oracle 8i I was able to select tables on a SQL2000 database (installed on a separate machine).

However I was forced to use the database link name HO.WORLD If I tried any other name for the db link I kept getting message that database link ANYNAME.WORLD connects to HO.WORLD.

At that time this did not bother me, so I just set my da link name to HO.WORLD and have been working fine ever since.

The problem is that now I need to connect to a different SQL2000 database and am getting same problem, only this time naming db link HO.WORLD although it works fine means that I have to erase previous connection as I cannot have two links with same name.

Any suggestions how can I solve this problem and maybe name db link something different.

James