The combination of the following three features allows you to update the structure of a table in a publication without requiring a full refresh to each replica that uses that publication:
▪SYNC MODE MAINTENANCE
▪REPLACE option in CREATE OR REPLACE PUBLICATION
▪table-level locking
One possible process for updating the tables in the publication is outlined below. First the master is upgraded, and then the replica(s) are upgraded.
1 Set the catalog’s sync mode to Maintenance so that the synchronization history feature is temporarily turned off.
2 Lock a table or set of tables in the publication with the LOCK TABLE command.
3 Make whatever table or schema changes are required. For example, modify a table, add a new table, or modify a publication.
4 Update the value of the bulletin board parameter SYNC_APP_SCHEMA_VERSION.
5 Upgrade application programs (if necessary).
6 Unlock the table(s) with the UNLOCK TABLE command.
7 Change the catalog’s sync mode from Maintenance back to Normal.
After the master has been upgraded, a nearly identical process is used to update the replica.