Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replicate abend

user10126973Jan 10 2020 — edited Jan 28 2020

HI All,

the extract and replicates up running since long time, today Morning we add a column into replciate side then immediately replicate abended with

Error OGG-00918 key column col_name is missing map

Source has 12 columns

Target has 13 columns(today morning added 13 th column)

OGG 12.3 Vesrsion

DB- 11.2.4 oracle

Please share your thoughts

Regards,

DR

Comments

Hao Shi-Oracle

Hi DR,

There must not be primary key / unique key in the target table and all the columns would be used as key columns.   Since the new column doesn't exist in the trail file, then you got the error message.

You could add primary key/ unique key into the target table or use keycols to list all the columns except the newly added one.

MAP xxx , target xxx , keycols (col1,col2...);

Regards,

Hao

user10126973

Hao,

thank you very much your quick response, Its fixed the issues as you suggested.

thanks a lot 

DR

Vikas Panwar

Hi @"user10126973"

if the answer helped you resolve the error, please mark it answered, correct. This will help others in same situation.

-VP

1 - 3

Post Details

Added on Jan 10 2020
3 comments
150 views