To execute Change Data Capture services on a module or a table.
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.
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 ) )
Executes a change data capture command.
Oracle module containing the tables being captured.
Module containing the tables that are being captured.
Table being captured. This should not be used by consistent cdc.
Start the cdc. This will create the cdc objects.
Extend the data window to allow access to the current changed data.
Add subscribers to the cdc.
Remove subscribers from the cdc.
Lock the subscriber so that the subscriber has repeated access to consistent data.
Unlock the subsciber.
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 the cdc tables.