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?
> janet <janet_at_telesph.com> wrote:
> >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';
Gary Assa wrote:
> 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}
in my example, "remote_database" was the example result of the command "uname -n"
if you wanted to pick on me because uname -n gives you the machine name and not the remote database, fine. but if you don't like the sample name i created...
janet Received on Thu Feb 20 1997 - 00:00:00 CST