Re: insert data from another database

From: <mpir_at_compuserve.com>
Date: Thu, 01 Jul 1999 20:42:50 GMT
Message-ID: <7lgjs7$ocj$1@nnrp1.deja.com>

Server should be the entry in your TNSNAMES.ORA that points to the other database. It should also be the same as the other database's GLOBAL_NAME value.

In article <377b3ccd.0_at_145.227.194.253>, "Mark G" <mgumbs_at_nospam.hotmail.com> wrote:
> You have to create a database link.
>
> Something like
>
> create database link <name>
> connect to <schema>
> identified by <password>
> using <server>
>
> Any good book should tell you what you need to know.
>
> M
>
> Markus Pesti wrote in message <7lfchk$4om$1_at_newsread.do.de.uu.net>...
> >I have to insert data into a table. These data are to be selected
from
> >another database.:
> >
> >SQL> insert into mytable select * from anothertable_at_anaotherdatabase;
> >
> >This produces the following error message:
> >
> >"ORA-02019: connection description for remote database not found"
> >
> >My question is, where is the connection description to be done?
> >
> >Thanks Markus
> >
> >
> >
> >
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 01 1999 - 15:42:50 CDT