Query and insert data into one db to another db

Question

I need to query data from one oracle database table and insert into another table in a different database, In the sense assume there are two databases called A and B. A has a_table and B has b_table. I need to query some records from a_table and insert into b_table. Is there any way to done in oracle db with out any third party script or program. Also this should be run automatically (may be twice a hour or if some data inserted into a_table)

Zynon Putney II · Accepted Answer · 2018-05-25 18:09:23Z

1

You can create a Database Link between two Oracle Databases, which will allow you to do what you're describing.

For example if you have a database link called "qa_link" you could do something like this:

insert into test_table@qa_link
(select column_names from local_table);

This database link could also be referenced in a trigger on the table with the data you want to copy, so it could happen in real time if you would prefer that to batching every couple of hours.

answered May 25, 2018 at 18:09

Zynon Putney II

6954 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query and insert data into one db to another db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related