We have two Dictionary Sources for Oracle CDC clients.
- Online Catalogue
- Redo Logs
Online Catalogue shall be used when table structure(Schema) change are not expected.
We hit above error when Dictionary Source is set to Online Catalogue and table structure(Schema) changes.
Redo Logs shall be used when table structure(Schema) can change while Oracle CDC pipeline is running.
Follow below steps to change Dictionary Source to Redo Logs:-
Oracle CDC stage --> Configuration --> Oracle CDC --> Dictionary Source --> Redo Logs