OMBCDC

Purpose

To execute Change Data Capture services on a module or a table.

Prerequisites

The module or table must be properly set up for change data capture. In addition, default agent must be configured with password and the module location must be registered.

Syntax

executeCDCCommand =  OMBCDC ( ( ORACLE_MODULE | MODULE | TABLE ) 
          "QUOTED_STRING" ( START_CDC | DROP_CDC | EXTEND_WINDOW | ( SUBSCRIBE 
          "QUOTED_STRING" ) | ( UNSUBSCRIBE "QUOTED_STRING" ) | ( 
          LOCK_SUBSCRIBER "QUOTED_STRING" ) | ( UNLOCK_SUBSCRIBER 
          "QUOTED_STRING" ) | GET_SUBSCRIBERS | PURGE_CDC ) )

Parameters

executeCDCCommand

Executes a change data capture command.

ORACLE_MODULE

Oracle module containing the tables being captured.

MODULE

Module containing the tables that are being captured.

TABLE

Table being captured. This should not be used by consistent cdc.

START_CDC

Start the cdc. This will create the cdc objects.

EXTEND_WINDOW

Extend the data window to allow access to the current changed data.

Add subscribers to the cdc.

UNSUBSCRIBE

Remove subscribers from the cdc.

LOCK_SUBSCRIBER

Lock the subscriber so that the subscriber has repeated access to consistent data.

UNLOCK_SUBSCRIBER

Unlock the subsciber.

GET_SUBSCRIBERS

Get the currenct subscribers from the cdc. This command does not go through the agent, so the repository must have direct access to the cdc objects for this to work.

PURGE_CDC

Purge the cdc tables.