The trigger on target becomes invalid after column change on the underlying table on source.
DDL change on the underlying table without reactivate config when ddl replication is disabled.
While all Shareplex processes are running on both source and target, do the following:
ON source:
1. sp_ctrl> activate config active_config
This will update the object cache for the column change if DDL replication is disabled.
ON target:
Perform the same ddl change on target and recompile trigger.
SQL> alter trigger <tirgger_name> compile;
Check if the trigger is valid now.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center