duplicate after restore

Posted by Roshan on Jan 26, 2023; 12:12pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/duplicate-after-restore-tp11508.html

Oracle 19c
Exadata

Hello Erman,

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);

Kindly advise.