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?
02-04-2003, 11:39 AM
Without knowing any details, I'd look into database links.
02-04-2003, 12:04 PM
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.