Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: insert data from another database

Re: insert data from another database

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Thu, 1 Jul 1999 11:13:01 +0100
Message-ID: <377b3ccd.0@145.227.194.253>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US