Mine process crashing with error: FATAL-6157: COL not found

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

For Dbvisit Replicate version 2.9.04 you can get the following error on Mine process: 

2018/06/10 19:25:02 FATAL> FATAL-6157: COL not found

In later releases the previous bug is fixed, for version 2.9.04 one has to use the following workaround:

CREATE TABLE dbvrep.DBRSCCOL_backup$ AS SELECT * FROM DBVREP.DBRSCCOL$; alter table dbvrep.DBRSCCOL$ drop primary key; create index dbvrep.DBRSIDX_CCOL$ on dbvrep.DBRSCCOL$ (CON_, INTCOL_, VALID_TO_SCN);