Alteration of Replication Definitions from the Primary Data Server

You can alter replication definitions from the primary data server.

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, create a stored procedure named rs_send_repserver_cmd 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 command.

For a full description of rs_send_repserver_cmd and the alter replication definition Replication Server command, see the Replication Server Reference Manual.