Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I create a link to a table in a remote database?
In article <3300E8B7.3C32_at_telesph.com>, janet <janet_at_telesph.com> wrote:
>Jared Hecker wrote:
>> See 'create database link' in your SQL reference guide.
>>
>> Simon Goland <sg_at_mda.ca> wrote:
>> >Can I create a link (or whatever it is called in the Oracle lingo) in my
>> >database here that will point to that remote table TABLE_A in the remote
>> >database? And if so, are there any special privileges the program on my
>> >end will need to have for that?
>
>Nice to see my two faaaavorite oracle guys chatting!
>Simon, I created a link to a remote database as such:
>i know you're on unix, so type
>uname -n
>on the remote database to give you the db name.
>Ex: remote_database
>
>go to local database and
>create public database link LINK_NAME
>connect to USER identified by PWD
>using 'remote_database';
>
Not many people out there will know what remote_database means.
If you are using a TCP/IP system, remote_database is: T:{machine_name}:{SID}
-- ========================================================= http://www.li.net/~gsa/index.html This is my signature file, not part of this mail message.Received on Tue Feb 18 1997 - 00:00:00 CST