Error: Replicat is abending with ORA-12899: value too large for column or Extract is not capturing changes.
Cause
Supplemental logging is not enabled properly at schema or table level.
Fix Commands
-- On Source Database (as SYSDBA)
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE FORCE LOGGING;
-- Enable schema level supplemental logging
ADD SCHEMATRANDATA schema_name ALLCOLS
-- OR for specific table
ADD TRANDATA schema_name.table_name ALLCOLSAfter enabling logging, restart the Extract process:
STOP EXTRACT ext1
START EXTRACT ext1Check status:
INFO EXTRACT ext1
SEND EXTRACT ext1, STATUSGoldenGate 19c | Supplemental Logging | CDC