Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OGG-00869 No unique key is defined for table

venkat vankayalaMar 26 2013 — edited Mar 26 2013
Hello DBA's,

We are implementing GoldenGate the very time in our environment , we are doing some testing and encountered below error as part of our testing , understood that we need keys defined on the tables columns that are involved in the GoldenGate replication process. Question is

I have included "DDL INCLUDE MAPPED" in the extract process and replication is working on target db of all listed schemas with our issues , until i executed below.

Created a table scott.dept1 on source with out any keys defined on column -> replicated on target successfully
Inserted one row in scott.dept1 on target , record inserted , issue with extract job -> error during the replication on target .

Below is the error on source :

2013-03-25 17:09:53 WARNING OGG-00869 No unique key is defined for table 'DEPT1'. All viable columns will be used to represent the key, but may not guara
ntee uniqueness. KEYCOLS may be used to define the key.
Using the following key columns for source table SCOTT.DEPT1: DEPTNO, DNAME, LOC.

On Target , log file showing
Wildcard MAP resolved (entry SCOTT.*):
MAP "SCOTT"."DEPT1", TARGET SCOTT."DEPT1";

If i am using this tool for migrating huge databases with out down time , how to bypass these error for the tables that are not defined with any of the keys on columns .
Can you guys share some knowledge on how you listed those table and what measures you took in Goldengate for these tables before you start extract or replicate process.
Looks like until this issue is fixed the replicat process will be in the Abended state .

Hope i descried my issues clearly.

Thanks
Venkat
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2013
Added on Mar 26 2013
6 comments
6,802 views