To switch from log-based capture to trigger-based capture, do the following:
-
In the omnient.ini file, set the trigger flag to 1 in the following line:
OracleCaptureTriggersOnly=1
-
Shut down and restart the Connect CDC Director.
-
Commit the model. Warning messages display that inform you to disable the logon and logoff trigger before updating the model in the Connect CDC MonCon or Connece CDC Console. You can disregard the warning and update the model before you disable the logon and logoff trigger.
-
Update the model.
-
Disable the logon and logoff trigger by running the following commands in the Connect CDC Director SQL window as user sys:
alter trigger sys.rp_logon_trg disable
alter trigger sys.rp_logoff_trg disable