need help/ideas regarding database comms.....

[Guest_imported]

OK, here is the situation;

We have two seperate ORACLE databases living across networks.
I need to have database A, contact database B, nightly and retrieve database
B's data into it's own tables.

Can this be done?
As stated, both are Oracle, and within the same network.
How do you get two seperate databases to communicate together ??

please help on this one, any ideas, suggestions, even book references would
be helpful.

 

[carp]

Create a database link on database A.

Then you can do things like

INSERT INTO A_Table (SELECT * FROM B_Table@DATABASE_B);

 

[raygg]

I have never used replication - would that handle this situation?

 

[Guest_imported]

considering that the databases are on different servers across network, is it hard to set it all up....i'm just not sure its as easy as creating a link...i mean, if you say, &quot;create database link <name>&quot;...is it going to understand where to find <name> .. ??

thanks for your help..

 

[karluk]

Quite right. In addition to creating the database link, you have to modify your tnsnames.ora on the database A server so that it contains an entry for database B on the other server. That will allow Oracle to figure out how to connect to database B when you issue SQL that uses the database link.