Re: Oracle Database Link Won't work

Sybrand is right in that your post is confusing.

By default a link name should be the remote database name dot the domain name and the using clause of the link would reference the TNSNAMES.ora service name for the remote database or as the version 9.2 DBA Admin manual puts it >>
Typically, a database link has the same name as the global database name of the remote database that it references. For example, if the global database name of a database is sales.us.oracle.com, then the database link is also called sales.us.oracle.com. <<

So if the remote database name is FIN1, the local database domain is WORLD, and the TNSNAMES.or entry for the database is FINANCE then create public database link FIN1.WORLD connect .... using 'FINANCE'

HTH -- Mark D Powell -- Received on Fri May 13 2005 - 09:10:02 CDT