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

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) ?

Topics
Migration & ModernizationDatabase
Tags
Migration & ModernizationAWS Database Migration ServiceOracle MigrationsOracle
Language
English
AWS-User-7313937
asked 2 years ago338 views
1 Answer
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

AWS
SV
answered 2 years 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

Relevant content