I posted this on my G+ stream... Why does Oracle add db_domain to db link names, it just causes problems when databases have to be migrated and does not add functionality. But I was told by an Oracle tech years ago (10 years now?) that db links are a very old part of the Oracle server software, coded at a very low level. -- Patrice <http://www.viadeo.com/fr/profile/patrice.boivin> [image: Facebook] <http://www.facebook.com/profile.php?id=100000206805521> [image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9> [image: Twitter] <http://www.twitter.com/PatriceBoivin> [image: Amazon]<http://www.amazon.com/gp/redirect.html?ie=UTF8&location=http%3A%2F%2Fwww.amazon.com%2Fgp%2Fregistry%2Fregistry.html%3Fie%3DUTF8%26type%3Dwishlist%26id%3D2JU0BBL2AGGSD&tag=casper-20> [image: Digg] <http://digg.com/patriceboivin> [image: Google]<http://https://sites.google.com/site/patriceboivin/> Get a signature like this. <http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19> CLICK HERE.<http://r1.wisestamp.com/r/landing?promo=19&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_19> -- //www.freelists.org/webpage/oracle-l