Preventing Key Changes

If you must add columns to the key that Extract is using as the row identifier for a table (primary key, unique key, KEYCOLS key, or all-column key) after Oracle GoldenGate has started processing journal data, follow these steps to make the change.

1. Issue the following command until it returns EOF, indicating that it has processed all of the existing journal data.

   INFO EXTRACT group
   

2. Stop Extract.

   STOP EXTRACT group
   

3. Make the change to the key.
4. Start Extract.

   START EXTRACT group