Hi All,
Oracle GoldenGate 21c (or earlier) where data for **NUMBER(10)** columns does not appear in the trail file, but values for plain NUMBER do. Please share your thought how to the value **NUMBER**(10) value in the trail file.
Eample :
In the GoldenGate trail file (checked via logdump), you see:
-
**NUMBER(10)** column → value is blank or missing.
-
**NUMBER** (without precision/scale) → value shows correctly
-
CREATE TABLE emp (
emp_id NUMBER(10),
salary NUMBER
);
In Trail File (Issue Case)
-
emp_id = missing in logdump
-
salary = shows fine
PLease let me kow if you have any thought for this problem.
Regards,
DR