Re: insert data from another database

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
>
>
>
>
Received on Thu Jul 01 1999 - 05:13:01 CDT