By using AWS re:Post, you agree to the Terms of Use

Read Oracle CDC without timestamp information

0

Good Day Everyone,

We are trying to capture CDC from the On-Prem Oracle Database using AWS DMS and using Oracle REDO logs for capturing the changed data (as there is no timestamp field available in the tables). Is there a better or different way to capture the CDC from on-prem Oracle DB (Obviously we cannot change anything/Schema on source side i.e. Oracle) ?

1 Answers
0

Amazon Database Migration Service does not need a timestamp based column in the source table to replicate it from on-prem Oracle DB. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.CDC

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions