A

replication

task can replicate data from one or more Oracle objects. When you configure the task, you can replicate all available objects through the selected connection, or you can select objects for replication by including or excluding a set of objects. You can also exclude rows and columns from the

replication

task. Associate a schedule with a

replication

task to specify when and how often the task runs.

When you replicate Oracle sources, you can replicate all current rows in the Oracle source. The names of source tables and fields can contain at most 30 characters. For example, the

replication

task creates a column name in an Oracle database based on the following 40-character field name:

TenLetters1234567890TenLettersXXXXXXXXXX

The

replication

task truncates the column name to the first 30 characters:

TenLetters1234567890TenLetters

If the truncation causes duplicate column names, the

replication

task replaces the last character of the duplicate column names with sequential numbers. The

replication

task also replaces the last character of duplicate table names from the same task.