Hi, I am using Oracle Warehouse Builder 9i to implement my data warehouse. Normally, it generates dblinks containing a TNS reference: create database link <hostname>@<connector> connect to <user> identified by <password> using '<hostname>'; But sometimes it generates dblinks containing a TNS *definition* instead: create database link <hostname>@<connector> connect to <user> identified by <password> using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=<hostname>)(PORT=<port>))) (CONNECT_DATA=(SERVICE_NAME=<service>)) )'; There are problems with the latter definition, but I have trouble finding how to avoid generating it. Oracle Support has so far not come up with a solution. Has anyone else had this problem? Regards, Kai Quale University of Oslo