My Oracle Support Banner

Column with varchar2 is not supplementally logged (Doc ID 2456170.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle GoldenGate - Version and later
Information in this document applies to any platform.


Columns with varchar2(1600 char) can not be added as supplemental logging column in NLS_CHARSET value of AL32UTF8 and max_string_size=extended.


SQL> show parameter max_string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_string_size                      string      EXTENDED


SQL> create table hshi.ttest1 (id int , name varchar2(1600 char));

Table created.


GGSCI (OGG123 as ogguser@ORAPROD) 2> add trandata hshi.ttest1

2018-10-29 20:31:23  WARNING OGG-06439  No unique key is defined for table TTEST1. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2018-10-29 20:31:23  INFO    OGG-15130  No key found for table HSHI.TTEST1.  All viable columns will be logged.

2018-10-29 20:31:24  INFO    OGG-15132  Logging of supplemental redo data enabled for table HSHI.TTEST1.

2018-10-29 20:31:24  INFO    OGG-15133  TRANDATA for scheduling columns has been added on table HSHI.TTEST1.

2018-10-29 20:31:24  INFO    OGG-15135  TRANDATA for instantiation CSN has been added on table HSHI.TTEST1.

2018-10-29 20:31:27  INFO    OGG-10471  ***** Oracle Goldengate support information on table HSHI.TTEST1 *****
Oracle Goldengate support native capture on table HSHI.TTEST1.
Oracle Goldengate marked following column as key columns on table HSHI.TTEST1: ID                                                <<<<<<<<<<<<<<<<<<<<<<<<< There is no PK/UI on this table, only ID is supplementally logged.
No unique key is defined for table HSHI.TTEST1.

SQL> select owner,  object_id, object_name from dba_objects where object_name='TTEST1' and owner='HSHI';

-------------------- ---------- ------------------------------
HSHI                      75040 TTEST1

SQL> select col#, segcol#, intcol#, property, name, type# from sys.col$ where obj#='75040';

      COL#    SEGCOL#    INTCOL#   PROPERTY NAME                                TYPE#
---------- ---------- ---------- ---------- ------------------------------ ----------
         1          1          1          0 ID                                      2
         2          2          2    8388736 NAME                                    1                                        <<<<<<<<<<<<<<<<<<<<< property of column "NAME" shows 8388736





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.