Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> oracle goldengate
kicha
post Jul 16 2015, 04:09 PM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 16-July 15
Member No.: 50,713



Add trandata on a partitioned table errors out:

ADD TRANDATA schema.table
ADD TRANDATA schema.table, cols (Pk)

tried both scenarios listed below and the table as primary key and unique key defined.

WARNING OGG-00869 No unique key is defined for table 'xxxxxxxxxx'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

using GG Version 11.2.1.0.20 on oracle database 10.2.0.4 (sun solaris)
Go to the top of the page
 
+Quote Post
kicha
post Jul 16 2015, 05:12 PM
Post #2


Newbie
*

Group: Members
Posts: 2
Joined: 16-July 15
Member No.: 50,713



QUOTE (kicha @ Jul 16 2015, 04:09 PM) *
Add trandata on a partitioned table errors out:

ADD TRANDATA schema.table
ADD TRANDATA schema.table, cols (Pk)

tried both scenarios listed below and the table as primary key and unique key defined.

WARNING OGG-00869 No unique key is defined for table 'xxxxxxxxxx'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

using GG Version 11.2.1.0.20 on oracle database 10.2.0.4 (sun solaris)


solved
the primary key status was not validated, alter and it worked.
Go to the top of the page
 
+Quote Post
burleson
post Jul 16 2015, 06:18 PM
Post #3


Advanced Member
***

Group: Members
Posts: 13,379
Joined: 26-January 04
Member No.: 13



Hi Kicha and welcome to the forum!

Glad to hear you got it working!

I have a page about this error:

http://www.dba-oracle.com/t_goldengate_ena...vel_logging.htm






--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Jhil
post Jan 1 2017, 01:31 PM
Post #4


Advanced Member
***

Group: Members
Posts: 37
Joined: 27-May 15
Member No.: 50,586



Hi Burleson,


Thanks for given link.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 27th April 2017 - 09:53 AM