Forum Stats

  • 3,768,479 Users
  • 2,252,798 Discussions
  • 7,874,596 Comments

Discussions

add schematrandata doesn't recognize the primary keys

User_A7RKT
User_A7RKT Member Posts: 221 Blue Ribbon

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.

Best Answer

Answers