Re: Select a from remote table

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 3 Sep 1998 21:18:04 +0200
Message-ID: <6smpv9$hq3$1@newton.a2000.nl>

>My Oracle Documentation (for ORA 7.x) states that the name of the dblink
>must match the name of the remote database. Are you sure about this?

That is correct, as of a certain version number. Don't ask me why though... Although some (obsolete) backward compatibility settings exists, I'd recommend using the database name for the database link as well. This also implies that one should not use the default database name, like ORCL or ORACLE.
>> IDENTIFIED BY password VALUE 'remote_domain'

May be a typo, but I'd use USING instead of VALUE:

identified by password USING 'remote_domain'.

Arjan. Received on Thu Sep 03 1998 - 14:18:04 CDT