Printable View
this is the scenario, two different databases (A&B) are running, both contain similar data in some of the tables but with different table structure, if i want to do a periodic update for database A by using data from database B, what would be the best method to do?
thanks...
Without knowing any details, I'd look into database links.
I'd create a stored proc that does the update bits and bobs you require, and I agree with above, the best way is to use a database link.
You can fire this procedure at set intervals using an oracle timed job.
