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 -> insert data from another database

insert data from another database

From: Markus Pesti <pesti_at_htwk-leipzig.de>
Date: Thu, 1 Jul 1999 11:33:19 +0200
Message-ID: <7lfchk$4om$1@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 - 04:33:19 CDT

Original text of this message

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