ORA-26688 Missing Key in LCR
The oerr utility lists
for the ORA-26888 error:
Cause: Metadata mismatch, or not enough information in the
user generated LCR.
Action: Alter the database object, or
provide all defined keys in the LCR.
-
The object for which an LCR is applying a
change does not exist in the destination database. In this case,
it is necessary to ensure that the object exists. Make sure that
the correct character case is used in rule conditions, Apply
handlers, and rule-based transformations.
-
Supplemental logging is not
specified for columns that require supplemental logging at the
source database. In this case, LCRs from the source database may
not contain values for key columns.
-
There may be problem with the primary key
in the destination table. If no primary key exists for the table
or if the target table has a different primary key than the
source table, substitute key columns can be specified using the
set_key_columns procedure in the dbms_apply_adm
package.
