Oracle as Replicate Data Server

Learn about the replicate database issues and considerations specific to the Oracle data server in a Sybase replication system.

• Oracle Replicate Data Servers
  You can replicate to an Oracle data server, using either ECDA Option for Oracle database gateway or ExpressConnect for Oracle.
• Replication Intrusions and Impacts on Oracle
  The only significant intrusions or impacts to the Oracle replicate database are the database objects created through the connection profile that creates three tables in the replicate database to support Replication Server operations.
• Oracle Replicate Database Permissions
  Replication Server requires a maintenance user ID that you specify using the Replication Server create connection command to apply transactions in a replicate database.
• Replicate Database Connectivity for Oracle
  Replication Server can connect to an Oracle replicate database using ECDA Option for Oracle or ExpressConnect for Oracle (ECO).
• Oracle Replicate Database Configuration
  The heterogeneous datatype support (HDS) feature of Replication Server provides configuration information that allows you to set up the HDS feature in the replicate Replication Server and the Oracle replicate database.
• Parallel DSI Threads for Oracle Replicate Database
  In a heterogeneous replication environment, parallel DSI must ensure that the commit order in the replicate database is same as in the primary database.