Updating/Inserting tables in one database from another database

How can I sync two databases and do a manual refresh on the entities on either of the database whenever I want?

Let's say I have two databases DB1(prod) and DB2(dev). I want to update/insert only a few tables from prod DB to dev DB. How could I achieve this? Is this possible instead of DBlink since I do not have privileges to create a database link?

Answers


If you only want to do a manual refresh set up an import/export/datapump script to copy the data across if there is not too much data involved. If there is a large amount of data you could write some pl/sql as described above to only move the new/changed rows. This will be easier if your data has fields such as created/updated_on


Need Your Help

Generic constraint inference in class signature

c# .net generic-constraints

I am frustrated by certain requirements when working with C# generic constraints, and I'd like to know if there is a way around my issues. If not, I'd like an explanation for why things don't work...

jasmin: mock instance of a class

javascript tdd jasmine

Is it possible to create a mock of an object obj such that Jasmine test like