PRIMARY/UNIQUE KEY constraint violation conflict on dbvrep table

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

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:

  1. Pause/stop APPLY

  2. Drop primary key 

  3. 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