Best / simplest way to transfer data from one Oracle database to another

Question

I need to develop an app that will pull data from Oracle database A (via a view sitting on A) and put that data into database B. The app will then expose the data in Database B via a rest API. So far the only technical restrictions are that this app has to run in JBOSS 5 App Server. I'm just wondering what the cleanest implementation should be. Should the transfer between DBs occur at the DB rather than app level? Any advice would be appreciated. The data size is minimal... 9-10 columns and about 1800 rows.

Answer 1

• There are bellow ways to do this.
  1. import export if you can manage to call import export api from you program.
  2. you can use materialized view by setting up db link.
  3. you can use third party tool like informatica.