Oracle GoldenGate Error Messages

OGG-01443

The key columns available in the table {0} may not guarantee uniqueness due to exclusion of virtual, nullable, or other unusable column(s).


Cause

A key column contains one or more of the specified column types. Oracle GoldenGate accepts nullable columns in a key definition if no other key exists, but does not accept the other specified column types in a key definition. If one or more columns of these types helps to provide uniqueness to the key, the exclusion of them leaves open the possibility for data inaccuracies on the target. Nullable columns by virtue of their definition cannot be considered unique.


Action

None, if you know that excluding these columns does not compromise uniqueness. To view the rules of Oracle GoldenGate key selection, see the installation and setup guide for the database type.