Devart Oracle Destination component loads data into Oracle tables. It has the following custom properties:
Property
|
Description
|
BufferSize
|
The maximal size of a data packet sent to the server. Default value is 262144.
|
Operation
|
A DML operation to apply to the target object. Default value is BulkInsert. The following values are supported:
| • | Insert - This is the most common operation. |
| • | Update - Devart Oracle Destination component in the Update mode enables updating data in a data source. Peculiarity of this action consists in the fact, that performing it requires using primary key values of the target table (the Id value for cloud sources). Thus, when performing an update, you must know and specify the primary key values of the target table to update a record. |
| • | Delete - Devart Oracle Destination component in the Delete mode enables deleting data from a data source. As well as for the update operation, you must know and specify the primary key values of the target table to delete a record. |
| • | BulkInsert - Devart Oracle Destination component uses Oracle-specific technique to quickly load data to Oracle. With OCI connections, Devart Oracle Destination uses direct path load interface to speed up loading. With Direct mode it uses array binding feature. |
|
RetryCount
|
The number of times to retry loading the data in case if it fails. Default value is 5.
|
RetryInterval
|
The number of seconds before repeating an attempt to load data. Default value is 1.
|
TableName
|
The name of an Oracle database object to load data into.
|