Avatar

Correct answer by
Community Advisor

Hi,

 

Find the highest ID in the table:

select max(itrackinglogid) from nmstrackinglogrcp;

 

Then update sequence to start 1 higher:

alter sequence NmsTrackingLogId restart with 9000;

 

Thanks,

-Jon

 

View solution in original post