Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
add schematrandata doesn't recognize the primary keys

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
-
I knew the cause. The constraints are invalidated.
Answers
-
I knew the cause. The constraints are invalidated.