Oracle Connector

Back Next

Oracle targets in replication tasks

When you replicate data to a database target, the

replication

task truncates the table name in the target database if the source object name exceeds 30 characters.

The following table describes the Oracle target properties in a

replication

task:

Property	Description
Connection	Name of the target connection. Select a target connection or create a new connection.
Target Prefix	String that prefixes the source object names to create names for the target objects in the target. For more information, see " Truncating Table Names " in Tasks help.
Enable Target Bulk Load	Uses Oracle bulk API to replicate data in bulk mode.
Load Type	Replicates full load of data from Oracle to other applications.
Delete Options	Not Applicable.
Commit size	Used for the replication task for all the runs. Defines the number of rows to commit. If you do not specify a value, the Secure Agent uses the default value 10000.