Modify Replicated Data

Learn how to modify replicated data and perform related operations to maintain replication.

Before you modify replicated data, carefully review the issues when you planned the replication system. When attempting to modify replicated data, know the dependencies that may exist and the sequence of tasks required to perform the procedure.

• Add a New Table
  To add a new source table, or add a new destination copy for an existing source table, follow the steps in the summary of procedures for replication.
• Renaming Replicated Tables
  To rename a replicated table, you need to specify the replication definition name and table names and follow the replication definition change request process.
• Add and Delete Columns in Source and Destination Tables
  Use the replication definition change request process to add or delete columns in the source and destination tables.
• Change Searchable Columns
  You can add searchable columns to a replication definition.
• Change Column Datatypes in a Source or Destination Table
  Use the replication definition change request process to change column datatypes in a primary and replicate table in a warm standby only setup.