以下是我用来将临时表dataTable中的数据批量复制到Oracle数据库中的destTable的代码。 dataTable大约有200万条记录。
但是它抛出了以下异常:
运行此数据加载过程的服务器肯定有足够的内存,看起来数据库服务器(linux)没有足够的内存。下面是数据库服务器内存截图:
有人能帮忙解决这个问题吗?谢谢。
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}\r\nBatchSize : {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}\r\nBatchSize : {2}, BulkCopyTimeout : {3}\r\n Error message {4}", dataTable.TableName, destTableName, bulkCopy.BatchSize.ToString(), bulkCopy.BulkCopyTimeout.ToString(), ex.ToString());
bulkCopy.Close();
bulkCopy.Dispose();
}
}
但是它抛出了以下异常:
![enter image description here](https://istack.dev59.com/qeKdB.webp)
![enter image description here](https://istack.dev59.com/2krMH.webp)
UCMExec.Utility
类的静态构造函数引发了异常。请编辑问题并包括此静态构造函数的源代码。 - Luke Woodward