ORA-26973 Automatic CDR Not Supported For Table which Has Long Columns (Doc ID 2632559.1)

Last updated on MAY 26, 2020

Applies to:

Symptoms

While replicating a table in GG with long column with Auto CDR it gives the below errors.

ORA-26973: automatic CDR not supported for table
"SCHEMANAME"."TABLENAME" which has long columns
ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM_INT_INVOK", line 4
ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM", line 83
ORA-06512: at line 2

SQL> BEGIN
 DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(
   schema_name => 'source1',
   table_name  => 'test1');
END;
/   2    3    4    5    6
BEGIN
*
ERROR at line 1:
ORA-26973: automatic CDR not supported for table "SOURCE1"."TEST1" which has
long columns
ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM_INT_INVOK", line 4
ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM", line 83
ORA-06512: at line 2

Cause

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