Oracle GoldenGate Error Messages

OGG-00560

Failed to change IDENTITY_INSERT state for table {0}


Cause

The execution of SET IDENTITY_INSERT failed with an error.


Action

Make sure that the user that is used to connect to the database has sufficient privileges to use SET IDENTITY_INSERT. The user must either own the object in question, or be a member of the sysadmin fixed server role, or the db_owner and db_ddladmin fixed database roles.