Configuration
Change Data Capture (CDC)
Configuration for change data capture
Change Data Capture (CDC)
Ora2Pg does not have a feature which allows importing data and only applying changes after the first import. But you can use the --cdc_ready option to export data with registration of the SCN at the time of the table export. All SCNs per table are written to a file named TABLES_SCN.log by default, it can be changed using -C | --cdc_file option.
These SCNs registered per table during COPY or INSERT export can be used with a CDC tool. The format of the file is tablename:SCN per line.
