PRIMARY/UNIQUE KEY constraint violation conflict on dbvrep table

Problem Description

The below article explains how to handle PRIMART/UNIQUE key conflicts in repository(DBVREP Schema) tables .

Solution

Conflict PRIMARY KEY constraint voilation of 'DBRSPK_OBJ$'.

Cannot insert duplicate key in object DBRSOBJ$'.

Resolve the conflict as follows:

SQL> create index DBRSIDX_COL$ on DBRSCOL$ (OBJ_, INTCOL_, VALID_TO_SCN);

4. Start/resume APPLY

Conflict unique key constraint violation of a dbvisit internal table

Example


Pause/stop APPLY
alter table DBRSCOL$ drop primary key;
create index DBRSIDX_COL$ on DBRSCOL$ (OBJ_, INTCOL_, VALID_TO_SCN);
Start/resume APPLY

Knowledge Base Dbvisit Replicate