OracleBulkCopy Class
An OracleBulkCopy object efficiently bulk loads or copies data into an Oracle table from another data source.
Class Inheritance
System.Object
System.OracleBulkCopy
Declaration
// C#
public sealed class OracleBulkCopy : IDisposableRequirements
| Provider | ODP.NET, Unmanaged Driver | ODP.NET, Managed Driver | ODP.NET Core |
|---|---|---|---|
| Assembly | Oracle.DataAccess.dll |
Oracle.ManagedDataAccess.dll |
Oracle.ManagedDataAccess.dll |
| Namespace | Oracle.DataAccess.Client |
Oracle.ManagedDataAccess.Client |
Oracle.ManagedDataAccess.Client |
| .NET Framework | See System Requirements | See System Requirements | - |
| .NET (Core) | - | - | See System Requirements |
Thread Safety
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
Remarks
The OracleBulkCopy class can be used to write data to Oracle database tables only. However, the data source is not limited to Oracle databases; any data source can be used, as long as the data can be loaded to a DataTable instance or read with an IDataReader instance.
Bulk copy of string data to destination number column is currently not supported.