Primary Database Object Marking

Individual tables to be replicated must be marked. Tables can be marked explicitly with the pdb_setreptable command or automatically during ra_admin init processing when the pdb_automark_tables configuration parameter is set to true.

Tables, stored procedures, and sequences (Oracle only) must be marked for replication and have replication enabled for the object (table, stored procedure, or sequence). LOB columns must have replication enabled, and the table that contains the LOB column must be marked for replication and have replication enabled for that table.

There are four types of objects that can be marked for replication in a primary database:

• Marking a Table in the Primary Database
  For transactions against a table to be replicated, the primary table in the primary database must be marked for replication, and replication must be enabled for that table.
• Marking a Stored Procedure in the Primary Database
  To replicate invocations of a stored procedure in the primary database, the stored procedure must be marked for replication, and replication must be enabled for that stored procedure.
• Enabling Replication for a LOB Column in the Primary Database
  For transactions that affect a LOB column to be replicated, the table that contains the LOB column must be marked for replication and have replication enabled.
• DDL Replication
  To replicate DDL, use pdb_setrepddl to set filtering rules accordingly.