---
title: "Discussion on \"How to Synchronize Oracle Identity Column Sequences\" | Hashnode"
description: "Discussion on \"How to Synchronize Oracle Identity Column Sequences\". Guide to synchronize Oracle Identity Column sequences to prevent unique constraint violations during data migrations between environments"
url: "https://hashnode.com/posts/how-to-synchronize-oracle-identity-column-sequences/668687b76da18a732216798e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to Synchronize Oracle Identity Column Sequences](https://lmoreaux.hashnode.dev/how-to-synchronize-oracle-identity-column-sequences?utm_source=hashnode&utm_medium=feed)

Guide to synchronize Oracle Identity Column sequences to prevent unique constraint violations during data migrations between environments

Jul 4, 2024 · 4 min read · lmoreaux.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[Louis Moreaux](https://hashnode.com/@lmoreaux)

@lmoreaux · Paris

  
[View profile](https://hashnode.com/@lmoreaux)

Oracle APEX developer

Oracle APEX Developer (Insum) from Paris Contributor of Flows for APEX Passionate about APEX and web development.

## Responses 1

Markdown supported · ⌘↵ to post

[Isaac Lañado](https://hashnode.com/@ilanado)

[Sep 6, 2024](https://hashnode.com/posts/how-to-synchronize-oracle-identity-column-sequences/668687b76da18a732216798e/comment/66db3c5502b1c2a754be2df2)

Great article!

I've been looking for something like this for quite some time, but instead of using identity column, we are using sequences, how can this be achieved with sequences?

[Louis Moreaux](https://hashnode.com/@lmoreaux)

[Sep 10, 2024](https://hashnode.com/posts/how-to-synchronize-oracle-identity-column-sequences/668687b76da18a732216798e/comment/66db3c5502b1c2a754be2df2#reply-66e03ac99ca5e49f264c2823)

Thanks [Isaac Lañado](https://hashnode.com/@ilanado)

It's a little bit more complicated, but if the names of your sequences can be derived from your table names then you simply have to look at the max id in the table and update your sequence accordingly.