Configure DDL Modification for Oracle GoldenGate for Sybase

Use the following steps to modify DDL for Oracle GoldenGate Extract for Sybase:

1. Pause or stop capturing application data for tables where you want to modify the DDL.

2. Ensure Extract processes all the transactions prior to making any DDL changes. An Event Marker table may help to ensure full completion.

3. Stop Extract.

4. At source, execute DELETE TRANDATA for the tables on which DDL has to be performed.

5. Execute the ALTER TABLE statement on the database side, to add or drop the column in or from the tables.

6. Re-enable trandata using the ADD TRANDATA command for the same tables at source.

7. Start Extract.