GoldenGate

Hi Folks,

I have a bi-directional replication configure and i am trying to setup auto CDR.

I have executed a script for table by table configuration, for the most part it worked but some tables returned the following error.  It worked in one side but failed on another.

Database are the same as it was cloned with PDB clone procedure.

Have anyone ran into this?

DB1

SQL> set echo on

SQL> BEGIN

  2   DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(

  3    schema_name => 'LOG',

  4    table_name  => 'EB_BKG_PAX_PMT_LG');

  5  END;

  6  /

Error starting at line : 530 in command -

BEGIN

DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(

  schema_name => 'LOG',

  table_name  => 'EB_BKG_PAX_PMT_LG');

END;

Error report -

ORA-01418: specified index does not exist

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

1. 00000 -  "specified index does not exist"

*Cause:   

*Action:

DB2

SQL> set echo on

SQL> BEGIN

  2   DBMS_GOLDENGATE_ADM.ADD_AUTO_CDR(

  3    schema_name => 'LOG',

  4    table_name  => 'EB_BKG_PAX_PMT_LG');

  5  END;

  6  /

PL/SQL procedure successfully completed.