ORACLE DATABASE :
While replication, When auto increment value exists same value in other table as well.
To adjust to max Auto increment value use the below query.
STOP Auto_increment turn it to OFF. Insert MAX value then start turn it to ON
EXAMPLE :
SET IDENTITY_INSERT Yaks ON INSERT INTO dbo.Yaks (YakID, YakName) Values(1, 'Mac the Yak') SET IDENTITY_INSERT Yaks OFF SELECT * from yaks
No comments:
Post a Comment