Replicat applying changes incorrectly in table with extended statistics
(Doc ID 2815001.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 12.3.0.1.2 and laterInformation in this document applies to any platform.
Symptoms
Replicat is applying data incorrectly on a table with extended statistics enabled.
If extended statistics is disabled in the target table, the replicat will abend with the following error:
ERROR OGG-01161 Bad column index (99) specified for table <SCHEMA_NAME>.<TABLE_NAME>, max columns = 98.
If extended statistics is enabled using the following on the target database:
select dbms_stats.create_extended_stats(ownname => '<SCHEMA_NAME>',tabname =>
'<TABLE_NAME>', extension => '("<COL1>","<COL2>")') from dual;
The replicat will apply the record in the target table and we see the
following message in the report file:
WARNING OGG-02544 Unhandled error (ORA-01840: input
value not long enough for date format) while processing the record at SEQNO
0, RBA 0 in Integrated mode. REPLICAT will retry in Direct mode.
And after that, the value in some of the columns will not match to the corresponding values
on the source.
The customer has the following parameter defined in the GLOBALS parameter file:
NO_USE_TRAILDEFS
and is using ASSUMETRAGETDEFS in the replicat parameter file.
Some additional columns were added to the table in the source after extended statistics was enabled.
Changes
Database was upgraded to 19c
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |