Replication Server Changes to Support Sequence Replication

By default, Replication Server does not support replication of Oracle sequence objects. You must make changes to Replication Server and the replicate Oracle database before you can replicate Oracle sequences.

For Replication Server, you must create a replication definition that defines a stored procedure to assist with sequence replication. Execute the $SYBASE/RAX-15_5/scripts/oracle/oracle_create_rs_sequence_repdef.sql script against your primary Replication Server after editing the script to replace values {pds} and {pdb} with the name of your primary Replication Server connection. You can find these values in the rs_source_ds and rs_source_db Replication Agent configuration properties.

Note: The replication definition assumes that a database replication definition exists. You may need to alter the definition if a database replication definition does not exist. For details, see comments in the oracle_create_rs_sequence_repdef.sql script.

In the replicate Oracle database, you must create a stored procedure to support sequence replication. Log in to the replicate Oracle database as the maintenance user defined in your Replication Server connection to the replicate database. Execute the $SYBASE/RAX-15_5/scripts/oracle/ oracle_create_replicate_sequence_proc.sql script to create the necessary stored procedure.

Note: The maintenance user defined in the Replication Server connection to the replicate database must have sufficient privileges to execute functions in the Oracle DBMS_SQL package. Also, this maintenance user must have authority at the replicate Oracle database to update any replicated sequence.