Step 2. Create objects and public synonyms

StepsTo create objects and public synonyms

  1. Create rs_info table and rs_lastcommit in the Oracle database as follows:

    1. Sign on to Oracle through DCO as the maintenance user (assuming that the maintenance user that you created has the resource role to create tables) and execute the script:

      isql –Umaintuser –Ppassword –SDCOServer
      
      -i $SYBASE/REP-12_6/scripts/hds_oracle_setup_for_replicate.sql
      

      NoteYou may receive a ORA-00942 message that a table or view does not exist. You may ignore the message.

    2. Create the public synonym rs_info for maintuser.rs_info.

      NoteDo this when Oracle is the target of only one Rep Server connection. If multiple Rep Server connections connect into this Oracle, do not create public synonyms.

      isql –Umaintuser –Ppassword –SDCOServercreate public synonym rs_lastcommit for maintuser.rs_lastcommitgo
      
      commit
      
      go
      
    3. Exit isql.