将大量数据从 DB2 传输到 Oracle？
我每天需要将大量数据（大约几百万条记录）从db2传输到oracle数据库。你能建议最好的执行方法吗？
I need every 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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
DB2 将允许您选择 Oracle 作为复制目标。这可能是每天最有效、最简单的方法，它还消除了您对“中间容器”的反对。
请参阅 此介绍（以及在线文档中的更多内容）了解更多信息。
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.
如果您只考虑说话速度，那么就这样做。
计算将 DB2 数据转储到平面文件所需的时间。
计算将该平面文件吸入 Oracle 需要多长时间。
这是你的基线，而且是免费的。如果您可以使用 ETL 工具来解决这个问题，那么请确定该工具的成本是否值得。
对于像这样的简单 ETL，我发现几乎没有什么可以比它更及时的。
这样做的缺点只是一般的文件操作BS...
所有这些小“细节”通常都会得到报酬与速度。当然，我有点开玩笑。他们并不总是那么友善。它们通常对于平稳运行的过程至关重要。
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...
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.
将数据转储到分隔文件。通过直接加载 sqlldr 作业加载到 Oracle。不性感，但速度很快。如果您可以位于同一子网上，那就最好了（通过网络推送数据不是您想要的）。在 cron 上进行设置，添加错误电子邮件警报
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