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 commands, see the Replication Server Reference Manual.

• Security Considerations
  When the rs_send_repserver_cmd procedure is invoked at the primary data server, Replication Agent passes corresponding Replication Command Language (RCL) directly to Replication Server. You should therefore consider carefully to whom execution privileges are assigned for the rs_send_repserver_cmd procedure, and assign privileges as appropriate for your environment and security policy.
• Limitations
  You cannot use the rs_send_repserver_cmd procedure to alter replication definitions for tables that contain columns of certain datatypes.