java - Best / simplest way to transfer data from one Oracle database to another -
i need develop app pull data oracle database (via view sitting on a) , put data database b. app expose data in database b via rest api. far technical restrictions app has run in jboss 5 app server. i'm wondering cleanest implementation should be. should transfer between dbs occur @ db rather app level? advice appreciated. data size minimal... 9-10 columns , 1800 rows.
- there bellow ways this.
- import export if can manage call import export api program.
- you can use materialized view setting db link.
- you can use third party tool informatica.
Comments
Post a Comment