-
data linking?
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.
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|