Transferring data between two databases if there is a LINK between them

Hello,

If this question has been asked before, pls excuse me but I tried looking for keywords and did not get enough answers.

I have 2 databases between which I need to transfer data and I am told that there is a "LINK" between these two databases (one is ORACLE 7.3 and the other is ORACLE 8.05 -- both are on UNIX).

I need to write a Stored Procedure to transfer the data from one table in DB#1 to two tables in DB#2, because the data has to be processed before it can be exported.

I would really be thankful if someone could tell me:

1. What a database link is?!?
2. How can I write a stored procedure to do this? Is there a link on the web where I can get some help for doing this?

Thanks for reading this till here, pls excuse my English!

I will look forward to your kind response.

Ben

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!