add schematrandata doesn't recognize the primary keys

User_A7RKT

Hi guys,

It's Oracle GoldenGate 19c on Oracle database 12.2, CDB and PDBs, Linux x86-64.

I want to add the schema soe in PDB1 to the GG replication.

When I executed the following command:

add schematrandata pdb1.soe

It reports a few tables do not have unique keys, here is one of them:

2021-01-21 11:48:57 INFO  OGG-10471 ***** Oracle Goldengate support information on table SOE.CUSTOMERS *****

Oracle Goldengate support native capture on table SOE.CUSTOMERS.

Oracle Goldengate marked following column as key columns on table SOE.CUSTOMERS: CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, NLS_LANGUAGE, NLS_TERRITORY, CREDIT_LIMIT, CUST_EMAIL, ACCOUNT_MGR_ID, CUSTOMER_SINCE, CUSTOMER_CLASS, SUGGESTIONS, DOB, MAILSHOT, PARTNER_MAILSHOT, PREFERRED_ADDRESS, PREFERRED_CARD

No unique key is defined for table SOE.CUSTOMERS.

But the table does have a PK:

SQL> select CONSTRAINT_NAME from user_CONSTRAINTS c where c.TABLE_NAME ='CUSTOMERS' and c.CONSTRAINT_TYPE = 'P' ;

CONSTRAINT_NAME

-----------------------

CUSTOMERS_PK

Can any one justify please?

Thanks in advance.

User_A7RKT

I knew the cause. The constraints are invalidated.

User_A7RKT

I knew the cause. The constraints are invalidated.