The techniques mentioned by Jason are very good and will get the job done. There exists a very little twist with SQL Developer, though. It caches the link specifications (host, assistance name, port) The 1st time it reads the tnsnames.ora file. Then, it doesn't invalidate the specs when the original entry is faraway from the tnsname.ora file. The c