To avoid having to quiesce the replication system before altering a replication definition, you can issue the Replication Server alter replication definition command from the primary data server and make schema changes to primary database objects at the same time. The propagation of changes to a replication definition can be automatically coordinated with data replication without having to stop the replication process.
To issue the Replication Server alter replication definition command from the primary data server, a stored procedure named rs_send_repserver_cmd must be created in the primary Oracle database. The SQL for creating this procedure is contained in the appropriate connection profile on Replication Server. For a list of connection profiles, use the Replication Server admin show_connection_profiles as described in the Replication Server Reference Manual.
For a full description of rs_send_repserver_cmd and the alter replication definition Replication Server command, see the Replication Server Reference Manual.
