Forum Stats

  • 3,760,119 Users
  • 2,251,647 Discussions
  • 7,870,987 Comments

Discussions

ERROR OGG-00918 Key column UNIQUE_ID is missing from map.

Robeen
Robeen Member Posts: 2,091 Silver Badge

Oracle DB 12.1.0.2

Solaris 11.4

Dear Team,

If I set a column which has been set as invisible on souce Oracle as primary key, kindly advise which modification should I make on Golden Gate extract and replicat parameter file so as the invisible field values are replicated on target Kudu?

Please find attached parameter files and logfiles.

Source table:

create table test(
"A" NUMBER(2),
"B" NUMBER(2),
"NAME" VARCHAR2(10 BYTE),
"ADDRESS" VARCHAR2(20 BYTE));

insert into test values(10,10,'new','new');
alter system switch logfile;
select * from test;
alter table TEST add UNIQUE_ID integer
generated by default on null as identity not null
/
alter table TEST add constraint PK_T_TABLE_TEST primary key (UNIQUE_ID)
/
alter table TEST modify UNIQUE_ID invisible
select * from TEST;

Thanks,

Roshan

Answers