Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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
AWS Database Migration ServiceOracleMigration & ModernizationOracle Migrations
Language
English

asked 4 years ago606 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

answered 4 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.

Relevant content