We're here to help!

PRIMARY/UNIQUE KEY constraint violation conflict on dbvrep table

Follow

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

 

Have more questions? Submit a request

Comments