The Replication Agent installation includes supplemental script changes to support additional Replication Server user-defined datatypes for new Oracle datatypes and replication of DDL commands.
The following revised Replication Server scripts are shipped with Replication Agent 15.2 and must be applied when the installed Replication Server is version 15.0.1 or earlier:
$SYBASE/RAX-15_2/scripts/oracle/ hds_oracle_new_setup_for_replicate.sql
$SYBASE/RAX-15_2/scripts/oracle/oracle_create_error_class_1_rs.sql
$SYBASE/RAX-15_2/scripts/oracle/ oracle_create_error_class_2_rssd.sql
$SYBASE/RAX-15_2/scripts/oracle/oracle_create_error_class_3_rs.sql
The following Replication Server scripts should be run manually against the RSSD when the installed Replication Server is version 15.0.1 or earlier:
$SYBASE/RAX-15_2/scripts/oracle/hds_oracle_funcstrings.sql
$SYBASE/RAX-15_2/hds_oracle_udds.sql
$SYBASE/RAX-15_2/hds_clt_ase_to_oracle.sql
Applying the script changes for user-defined datatypes
If your Replication Server is version 15.0.1 or earlier, apply the following script to support replication of DDL to an Oracle replicate database:
$SYBASE/RAX-15_2/scripts/oracle/hds_oracle_new_setup_replicate.sql
This script defines Replication Server objects that must be created in the replicate database. Use this script instead of the hds_oracle_setup_replicate.sql script provided in the Replication Server install directory. This revised script contains additional changes to support Oracle-to-Oracle DDL replication.
To correctly define the Oracle error class for Replication Server 15.0.1 or an earlier version:
Apply the following script at Replication Server:
$SYBASE/RAX-15_2/scripts/oracle/ oracle_create_error_class_1_rs.sql
Apply the following against your RSSD:
$SYBASE/RAX-15_2/scripts/oracle/ oracle_create_error_class_2_rssd.sql
Apply the following script at Replication Server:
$SYBASE/RAX-15_2/scripts/oracle/ oracle_create_error_class_3_rs.sql
See Chapter 4, "Database Server Issues,” in the Replication Server Heterogeneous Replication Guide.
