将数据批量插入Oracle数据库的最佳方法 [英] Best way to bulk insert data into Oracle database

问题描述

我将创建许多数据脚本，例如INSERT INTO和UPDATE

I am going to create a lot of data scripts such as INSERT INTO and UPDATE

如果没有1,000,000，将有100,000条记录

There will be 100,000 plus records if not 1,000,000

将这些数据快速导入Oracle的最佳方法是什么?我已经发现SQL Loader不适合这样做，因为它不会更新单个行.

What is the best way to get this data into Oracle quickly? I have already found that SQL Loader is not good for this as it does not update individual rows.

谢谢

更新:我将编写一个应用程序，用C#来实现这一点

UPDATE: I will be writing an application to do this in C#

推荐答案

通过

Load the records in a stage table via SQL*Loader. Then use bulk operations:

• 插入选择(例如)
• 大量更新("Oracle-具有内部连接的更新语句" )
• 或单个合并声明

• INSERT INTO SELECT (for example "Bulk Insert into Oracle database")
• mass UPDATE ("Oracle - Update statement with inner join")
• or a single MERGE statement

这篇关于将数据批量插入Oracle数据库的最佳方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！