Database Software

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!

datapump import duplicate IDs

Roshan BisnathJan 26 2023

Oracle 19c
Exadata

Hello Team,

after performing an export, import of a table from 12.2.0 to 19.0 database, we had to reset the sequence number after import.

Some 814 records had duplicate sequence numbers – is that possible?

The DDL statement for the table mentions creating the sequence from 1 whereas it should have been 201021 to continue the previous sequence

The DDL statement for the MU_AT table was changed to start at 255000

alter table "BPMDATAPRODMU"."MU_AT" modify ID generated as always as identity (start with 255000);