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

Ensure Extract processes all the transactions prior to making any DDL changes. An Event Marker table may help to ensure full completion. See Maintaining the DDL Marker Table for reference.

Stop Extract.

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

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

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

Start Extract.