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:
Pause/stop APPLY
Drop primary key
Create index on DBRSCOL$ using columns OBJ_, INTCOL_ and VALID_TO_SCN
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