PostgreSQL: Prerequisites for Configuring DDL

The DDL changes in the source database are not automatically handled by the Extract process in PostgreSQL. Perform the following steps before making any DDL changes on the source table.

1. Stop the application data to the tables for which the DDL needs to be modified.
2. OGG Extract has captured all the changes prior to the DDL change.
3. Stop the Extract.
4. Execute DELETE TRANDATA on the table.
5. Make the required DDL Change using ALTER TABLE ADD COLUMN/DROP COLUMNcommand.
6. Execute ADD TRANDATA on the table.
7. Start the Extract.
8. Resume the application data on the table.