Updating multiple DB with one query

Posted on 2009-04-20
Last Modified: 2013-12-07
 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
Question by:pandkyon
    LVL 142

    Accepted Solution

    not really. each table (which includes if they are in different databases) must be updated individually.
    LVL 35

    Assisted Solution

    even if the tables are identical in both databases, you still need two separate connections

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now