Link to home
Create AccountLog in
Avatar of KingMooBot
KingMooBotFlag for United States of America

asked on

Copy data from multiple Oracles DBs and insert it all to one Oracle DB

I would like to know the best way to copy data from many different tables, databases, and servers to one database (with VB.NET). I was previously loading many CSV reports from the sources using oracle 11g's "bulkcopy" but this proved to be cumbersome.

I also need to modify some of the data before (or after I guess...)  it's inserted to its destination.
ASKER CERTIFIED SOLUTION
Avatar of mrjoltcola
mrjoltcola
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of KingMooBot

ASKER

thanks that's a perfect solution!
For a one time copy, you can also use the simple:

On db2:

  create table tab1 as select * from tab1@db1


Materialized views, however, allow you to do updateable views that replicate back to parent, and/or faster refreshes when using materialized view logs.

Cheers.