OracleBulkCopy Members
OracleBulkCopy members are listed in the following tables.
OracleBulkCopy Constructors
OracleBulkCopy constructors are listed in Table 17-1.
Table 1 OracleBulkCopy Constructors
| Constructor | Description |
|---|---|
| OracleBulkCopy Constructors | OracleBulkCopy constructors create new instances of the OracleBulkCopy class |
OracleBulkCopy Properties
OracleBulkCopy properties are listed in Table 17-2.
Table 2 OracleBulkCopy Properties
| Property | Description |
|---|---|
| BatchSize | Specifies the number of rows to be sent as a batch to the database |
| BulkCopyOptions | Specifies the OracleBulkCopyOptions enumeration value that determines the behavior of the bulk copy operation |
| BulkCopyTimeout | Specifies the number of seconds allowed for the bulk copy operation to complete before it is aborted |
| ColumnMappings | Specifies the column mappings between the data source and destination table |
| Connection | Specifies the OracleConnection object that the Oracle database uses to perform the bulk copy operation |
| DestinationPartitionName | Specifies the database partition that the data is loaded into |
| DestinationSchemaName | Specifies the database schema that the data is loaded into |
| DestinationTableName | Specifies the database table that the data is loaded in |
| NotifyAfter | Defines the number of rows to be processed before a notification event is generated |
OracleBulkCopy Public Methods
OracleBulkCopy public methods are listed in Table 17-3.
Table 3 OracleBulkCopy Public Methods
| Method | Description |
|---|---|
| Close | Closes the OracleBulkCopy instance |
| Dispose | Releases any resources or memory allocated by the object |
| WriteToServer | Copies rows to a destination table |
OracleBulkCopy Events
OracleBulkCopy events are listed in Table 17-4.
Table 4 OracleBulkCopy Events
| Event | Description |
|---|---|
| OracleRowsCopied | Triggered every time the number of rows specified by the OracleBulkCopy.NotifyAfter property has been processed |