DMS add column with Oracle SCN

Question

Hi, I have been trying to find documentation on how to include a column with the Oracle SCN in the DMS task output  https://docs.aws.amazon.com/dms/latest/sbs/oracle-s3-data-lake-step-5.html#oracle-s3-data-lake-step-5-ongoing-replication
They mention that are two ways to serialize the data, one is using TimeStampColumnName , this does not work for me because I have transactions occurring at the same time, the documentation also mention a second way adding a column with the Oracle SCN but I can't find any documentation on how to do it.

Can anyone help?

Many thanks :-)

JT · Accepted Answer

I believe that found a solution, I created a transformation rule in DMS using the expression AR_H_CHANGE_SEQ, this added a new column in my S3 data - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Expressions.html#CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Expressions-Headers

JT · Answer

Hi Didier, thanks for your reply, but what I want to achieve is to include the SCN in the DMS task output, I need to be able to identify the latest transaction for a given record

Didier Durand · Answer

Hi,

This blog post explains how to migrate an Oracle db with DMS by using SCN: https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/

Best,

Didier

DMS add column with Oracle SCN

Add your answer

Relevant content