Re: OGG-01169

Posted by Roshan on Oct 05, 2019; 7:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/OGG-01169-tp7738p7756.html

I tried the steps from Doc ID 2355832.1

I see the warning message below

2019-10-05T04:59:57.803+0400 INFO OGG-06441 Oracle GoldenGate Delivery for Oracle, reploggt.prm: Unique key OGG_CB_CR_DB_NOTES2#$1 for table CB_CR_DB_NOTES cannot be used due to the inclusion of virtual columns, or user-defined datatypes, or extended long varchar columns, or function-based index columns.
2019-10-05T04:59:57.803+0400 WARNING OGG-06440 Oracle GoldenGate Delivery for Oracle, reploggt.prm: No viable unique key is defined for table CB_CR_DB_NOTES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.