OracleBulkCopy Properties

OracleBulkCopy properties are listed in Table 17-5.

Table 17-5 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

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