下面是我用于将数据从临时表dataTable批量复制到Oracle数据库中的destTable的代码. dataTable有大约200万条记录.

using (OracleBulkCopy bulkCopy = new OracleBulkCopy(VMSDATAConnectionString))

{

try

{

foreach (OracleBulkCopyColumnMapping columnMapping in columnMappings)

bulkCopy.ColumnMappings.Add(columnMapping);

bulkCopy.DestinationTableName = destTableName;

//bulkCopy.BatchSize = dataTable.Rows.Count;

//bulkCopy.BulkCopyTimeout = 100;

int defaultSize = 5000;

int.TryParse(ConfigurationManager.AppSettings["OracleBulkCopyBatchSize"], out defaultSize);

bulkCopy.BatchSize = defaultSize;

int timeOut = 100;

int.TryParse(ConfigurationManager.AppSettings["OracleBulkCopyTimeout"], out timeOut);

bulkCopy.BulkCopyTimeout = timeOut;

Console.WriteLine("Bulk insert from {0} to {1} started at: {2}

BatchSize : {3}, BulkCopyTimeout : {4} ", dataTable.TableName, destTableName, DateTime.Now.ToString("HH:mm:ss"), bulkCopy.BatchSize.ToString(), bulkCopy.BulkCopyTimeout.ToString());

bulkCopy.WriteToServer(dataTable);

Console.WriteLine("Bulk insert from {0} to {1} finished at: {2}", dataTable.TableName, destTableName, DateTime.Now.ToString("HH:mm:ss"));

}

catch (Exception ex)

{

Console.WriteLine("Error happened during bulk copy from {0} to {1}

BatchSize : {2}, BulkCopyTimeout : {3}

Error message {4}", dataTable.TableName, destTableName, bulkCopy.BatchSize.ToString(), bulkCopy.BulkCopyTimeout.ToString(), ex.ToString());

bulkCopy.Close();

bulkCopy.Dispose();

}

}

但是它引发以下异常：

运行此数据加载过程的服务器肯定有足够的内存,看起来数据库服务器(linux)没有足够的内存.下面是数据库服务器内存的屏幕截图：

谁能解决这个问题？谢谢.