add schematrandata doesn't recognize the primary keys — oracle-tech

    Forum Stats

  • 3,715,825 Users
  • 2,242,889 Discussions
  • 7,845,623 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

add schematrandata doesn't recognize the primary keys

User_A7RKT
User_A7RKT Member Posts: 219 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

Sign In or Register to comment.