In addition to controlling which tables are captured, it is also possible to add and remove items to be excluded from capture based on other parameters including: User. The basic syntax varies slightly based on the current state of the configuration and can be can be specified one or more times per command line:
SQDCONF Create state syntax:
--exclude-user=<variable>
SQDCONF Modify state syntax:
--add-excluded-user=<variable> | --remove-excluded-user=<variable>The only filter available in the Oracle capture is the value of the user-id associated with the transaction or program making Oracle data changes.
The following example adds a user exclusion for all Engines to prevent cyclic updates in an Active/Active Replication configuration:
sqdconf modify <SQDATA_VAR_DIR/oracdc1/oracdc1.cab --add-excluded-user=<sqdata_user>Note:
- The modification to the configuration file must be applied to have the capture agent recognize the updated configuration.
- In the case where active/active replication is to be deployed, there must be an --exclude-user=<sqdata_user> where <sqdata_user> must be the oracle user under which the engine runs.