You can replicate Oracle data to a target by using the replication task. You might replicate data to back up the data or perform offline reporting. You can replicate data in Oracle objects to databases or flat files.
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.