To switch from trigger-based capture to log-based capture, do the following:
-
In the omnient.ini file, set the trigger flag to 0 in the following line:
OracleCaptureTriggersOnly=0
-
Shut down and restart the Connect CDC Director.
-
Commit the model. Warning messages display that inform you to enable the logon and logoff trigger before updating the model in the Connect CDC MonCon or Connece CDC Console.
-
Enable 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 enable alter trigger sys.rp_logoff_trg enable
-
Update the model.