• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

Updating multiple DB with one query

Hi
 Is there a way to update multiple databases with one query?  I wish to use insert data from one oracle db into 2 other dbs.  how do I set up the query to open the other databases and insert the data?

Thanks in advance
P
0
pandkyon
Asked:
pandkyon
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
not really. each table (which includes if they are in different databases) must be updated individually.
0
 
YZlatCommented:
even if the tables are identical in both databases, you still need two separate connections
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now