insert data from another database

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