OraFAQ Forum: Performance Tuning » Oracle Golden gate- Compression tables

Home » RDBMS Server » Performance Tuning » Oracle Golden gate- Compression tables (Oracle 12CR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Golden gate- Compression tables [message #668831]

Fri, 16 March 2018 05:47

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Team,

We are getting below error when trying to replicate compressed tables from source DB to target DB in Oracle 12CR2.

2018-03-15T23:27:20.288-0400 ERROR OGG-01433 Oracle GoldenGate Capture for Oracle, com_m1_e.prm: Failed to validate table COMCAST_AA_UAT.INVOICE. The table is compressed and extract will not be able to extract data from Oracle logs.
2018-03-15T23:27:20.288-0400 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, com_m1_e.prm: PROCESS ABENDING.
2018-03-15T23:27:22.193-0400 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.

Please advise how we can implement data replication in Golden gate for compressed tables without uncompressing it.

Your suggestion is valuable to us.

Thanks,
SRK

[Updated on: Fri, 16 March 2018 05:48]

Report message to a moderator

Re: Oracle Golden gate- Compression tables [message #668854 is a reply to message #668831]

Mon, 19 March 2018 05:46

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Upgrade GG

Report message to a moderator

Re: Oracle Golden gate- Compression tables [message #668969 is a reply to message #668854]

Mon, 26 March 2018 13:42

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Thank you...But advise us for which version of GG to update?

Thanks,
SRK

Report message to a moderator

Re: Oracle Golden gate- Compression tables [message #668999 is a reply to message #668969]

Wed, 28 March 2018 07:59

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

We have already upgraded to 12.3 and also it is in integrated mode, but still its not working. Data not replicating for compressed tables.

Please advise.

Thanks,
SRK

Report message to a moderator

Re: Oracle Golden gate- Compression tables [message #669016 is a reply to message #668999]

Thu, 29 March 2018 02:24

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

I've hit about my limit of the topic at this point I'm afraid. I can only advise reading the documentation/support notes in absence of anyone else weighing in.

Report message to a moderator

Previous Topic:	Reorganizing index datafiles with tables in partition (merged)
Next Topic:	optimzer dynmic smpling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 14:49:41 CST 2025