My Oracle Support Banner

BEGIN DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR generates ORA-26970 (Doc ID 2583107.1)

Last updated on SEPTEMBER 05, 2019

Applies to:

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

Symptoms

In the process of using Auto CDR and using ogg v12.3.0.1.4 and Oracle db 12.2.0.1

SQL> BEGIN DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(schema_name => '<SCHEMA NAME>',table_name => '<TABLE NAME>'); END;

2 /

BEGIN DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(schema_name => '<SCHEMA NAME>',table_name => '<TABLE NAME>'); END;

*

ERROR at line 1:

ORA-26970: table "<TABLE NAME>'" does not contain a primary key constraint

ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM_INT_INVOK", line 4

ORA-06512: at "SYS.DBMS_GOLDENGATE_ADM", line 83

ORA-06512: at line 1



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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