When a sequence is marked for replication, changes to that sequence against sys.seq$ are captured and sent to Replication Server in the form of parameters passed to a procedure. The procedure (rs_update_sequence) must be installed at the standby site as part of system setup, as well as a function replication definition for that procedure. At the standby site, an implementation of rs_update_sequence will increment a same-named sequence until its value is equal to the value at the primary site. Sybase provides scripts with installation to create the rs_update_sequence stored procedure and function replication definition. The scripts’ locations are as follows:
$SYBASE/RAX-15_0/scripts/ oracle_create_replicate_sequence_proc.sql $SYBASE/RAX-15_0/scripts/ oracle_create_rs_sequence_repdef.sql
