To create objects and public synonyms
Create rs_info table and rs_lastcommit in the Oracle database as follows:
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
You may receive a ORA-00942 message that a table or
view does not exist. You may ignore the message.
Create the public synonym rs_info for maintuser.rs_info.
Do 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
Exit isql.