Marking Tables to Prepare for Replication Testing

Mark tables in the primary Oracle database that you want to replicate to the Sybase IQ database.

In these examples, dbo is the table owner of testtab in the pdb1 database of the ORA_DS primary Oracle data server. c1, c2, and c3 are columns in testtab with int, int, and char(10)datatypes, respectively.

  1. Insert data rows into testtab in Oracle for testing replication and verify the inserts are successful.
  2. Mark testtab for replication with the pdb_setreptable Replication Agent command.
    See "Marking tables in the primary database," in Chapter 2, "Setting Up and Configuring Replication Agent" in the Replication Agent Administration Guide in the Replication Server Options 15.5 documentation.
Parent topic: Scenario for Replication to Sybase IQ