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.
    1. import export if can manage call import export api program.
    2. you can use materialized view setting db link.
    3. you can use third party tool informatica.

Comments

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -