Replicat applying changes incorrectly in table with extended statistics
(Doc ID 2815001.1)
Last updated on OCTOBER 18, 2021
Applies to:Oracle GoldenGate - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
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:
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.
Database was upgraded to 19c
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