username$ contains NULL for new rows inserted after the column was added to an existing change table (Doc ID 1300782.1)

Last updated on DECEMBER 02, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

After adding the user_id control column to an existing change table using:

begin
    dbms_cdc_publish.alter_change_table(
    owner=>'CDC',
    change_table_name=>'T1_CT',
    operation=>'ADD',
    column_list=>null,
    rs_id=>'n',
    row_id=>'n',
    user_id=>'y',
    timestamp=>'n',
    object_id=>'n',
    source_colmap=>'n',
    target_colmap=>'n',
    ddl_markers=>'n');
end;
/

New rows inserted into the change table will contain NULL for the column username$.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms