Use goldengate to do data synchronization process, need according to the date and time to filter the source library a data table, please comment, filter syntax is how to write?
Example:
1, requirement: the source table to filter out time is greater than or equal to the 2019-11-12 data, then synchronization to the target table,
Can find the relevant results by Sql statements, namely select * from table name where report_time & gt;=to_date (' 2019-11-12 ', '- dd yyyy - mm);
But in the extract or replicat don't know how to write, after preliminary test, seemingly because to_date function problem, use the where and the filter are not
Description: 2, that the time field report_time format as follows: the 2019-11-12 07:10:01. 000000
3, oracle versions of 11, goldengate version of 12
Leave you a great god, filter statement how to write, thank you!