data linking?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: data linking?

  1. #1
    Join Date
    Mar 2001
    Posts
    23

    Question 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...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Without knowing any details, I'd look into database links.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2003
    Location
    UK
    Posts
    4
    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
  •  


Click Here to Expand Forum to Full Width