5 Modifying Objects in the Oracle GoldenGate Configuration

This chapter contains instructions for performing some common maintenance tasks when using the Oracle GoldenGate replication solution. This chapter contains the following sections:

• Section 5.1, "Modifying Columns of a Table"

5.1 Modifying Columns of a Table

To modify columns of a table:

1. Suspend activity on the source database for all tables that are linked to Oracle GoldenGate.

2. Start GGSCI.

3. In GGSCI, issue this command for the Replicat group:

   INFO REPLICAT group
   

4. On the Checkpoint Lag line, verify whether there is any Replicat lag. If needed, continue to issue INFO REPLICAT until lag is zero, which indicates that all of the data in the trail has been processed.

5. Stop the Replicat group.

   STOP REPLICAT group
   

6. Perform the table modifications on the target databases.

7. Start the Replicat process.

   START REPLICAT group
   

8. Allow user activity to resume on all of the source tables that are linked to Oracle GoldenGate.