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 laterInformation 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 |