Showing posts with label ORACLE DATABASE Problem with Auto Increment value. Show all posts
Showing posts with label ORACLE DATABASE Problem with Auto Increment value. Show all posts

Wednesday, January 6, 2016

ORACLE DATABASE : Replication Problem with Auto Increment value

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 

lvalue vs rvalue

  1. What is an lvalue? An lvalue is an object that: Has an identifiable memory location. Has a name (in most cases). Can appear on th...