By default, Replication Server is not installed with support for replication of Oracle sequence objects. Changes are required to Replication Server and the standby Oracle database before replication of Oracle sequences is possible.
For Replication Server, you must create a replication definition that defines a stored procedure to assist with sequence replication. To do this, execute the $SYBASE/MA-15_1/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. These values can also be found in the rs_source_ds and rs_source_db Mirror Replication Agent configuration properties.
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 standby Oracle database, you must create a stored procedure to support sequence replication. To do this, log in to the standby Oracle database as the maintenance user defined in your Replication Server connection to the standby database. Then, execute the $SYBASE/MA-15_1/scripts/oracle/ oracle_create_replicate_sequence_proc.sql script to create the necessary stored procedure.
The maintenance user defined in your Replication Server
connection to the standby database must have sufficient privileges
to execute functions in the Oracle DBMS_SQL package. Also,
this maintenance user must have authority at the standby Oracle
database to update any sequence that is replicated.
