Spaces in Source Table show as NULL in Change Tables

The Problem

We came across an issue within our Change Data Capture configuration where we would get NULL values in our change tables, but we didn’t understand why because we had unconditional log groups for the columns which were showing as NULL in the change table.

The Cause

Spaces input by users caused the NULL values to be shown in the change table. We were running with Oracle version patchset 3.

The Solution

A case was raised with Oracle and the fix was added to patchset 5. After applying this patch the issue was no longer present. However, there is another issue in patchset 5 that we hit which requires patching to patchset 8…The issue was an ORA-03113: end-of-file on communication channel error message for a particular query and the trace file show the following error:

———– messages from pre-loading .sym files:
Symbol file D:\Oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\oraclsra11.SYM does not match binary.

I have written in a little more detail about the symbol file oraclsra11.SYM does not match binary error message in another article so check that out if you want to know more.

Like it, share it...

Category: Change Data Capture

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *