Applying Script Changes for User-Defined Datatypes

Apply these script changes to use Oracle user-defined datatypes.

1. If your Replication Server is version 15.0.1 or earlier, apply this script to support replication of DDL to an Oracle replicate database:

   $SYBASE/RAX-15_5/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.

2. To correctly define the Oracle error class for Replication Server 15.0.1 or an earlier version:

   • Apply this script at Replication Server:

     $SYBASE/RAX-15_5/scripts/oracle/ oracle_create_error_class_1_rs.sql

   • Apply this script against your RSSD:

     $SYBASE/RAX-15_5/scripts/oracle/ oracle_create_error_class_2_rssd.sql

   • Apply this script at Replication Server:

     $SYBASE/RAX-15_5/scripts/oracle/ oracle_create_error_class_3_rs.sql