Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert identity column to a sequence

DSJ-OracleMay 11 2020 — edited May 11 2020

I am on Oracle DB 12.1.0.2 and I'm trying to convert the existing identity columns on tables to use a normal sequence. So I want to remove the identity reference.

Is there a way of doing this?

The reason is that identity columns are causing an issue during an import into another db.

Cheers

Added on May 11 2020

#general-database-discussions

1 comment

798 views