Transfer large amount of data from DB2 to Oracle?

I need ever开发者_如何转开发y day to transfer large amounts of data (about several millions records) from db2 to oracle database. Could u suggest the best perfoming method to do that?

DB2 will allow you to select Oracle as a replication target. This is probably the most efficient and easiest way to do it every day, it also removes the "intermediate container" objection that you have.

See this introduction (and more from the documentation online) for more.

If you're only talking speed then do this.

Time how long it takes to dump the DB2 data to a flatfile.

Time how long it takes to suck that flatfile into Oracle.

there's your baseline and it's free. If you can beat that with an ETL tool, then decide if the cost of the tool is worth it.

For a simple ETL like this, there's little that I've found that can beat this on time.

The downside of this is just general file manipulation BS...

• how do you know when to read from the file
• how do you know that you got all the rows
• how do you resume when something breaks

All those little "niceties" usually get paid for with speed. Of course, I'm joking a bit. They aren't always a little nicety. They are often essential for a smooth running process.

Dump out data to delimited file. Load to Oracle via DIRECT load sqlldr job. Not sexy, but fast. If you can be on same subnet that would be best (pushing data across the network is not what you want). Set this up on a cron, add email alerts on errors