- 3,715,825 Users
- 2,242,889 Discussions
- 7,845,623 Comments
add schematrandata doesn't recognize the primary keys
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' ;
Can any one justify please?
Thanks in advance.