Home » RDBMS Server » Performance Tuning » Oracle Golden gate- Compression tables (Oracle 12CR2)
Oracle Golden gate- Compression tables [message #668831] Fri, 16 March 2018 05:47 Go to next message
srinivas.k2005
Messages: 395
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 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Upgrade GG
Re: Oracle Golden gate- Compression tables [message #668969 is a reply to message #668854] Mon, 26 March 2018 13:42 Go to previous messageGo to next message
srinivas.k2005
Messages: 395
Registered: August 2006
Senior Member
Thank you...But advise us for which version of GG to update?


Thanks,
SRK
Re: Oracle Golden gate- Compression tables [message #668999 is a reply to message #668969] Wed, 28 March 2018 07:59 Go to previous messageGo to next message
srinivas.k2005
Messages: 395
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
Re: Oracle Golden gate- Compression tables [message #669016 is a reply to message #668999] Thu, 29 March 2018 02:24 Go to previous message
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.
Previous Topic: Reorganizing index datafiles with tables in partition (merged)
Next Topic: optimzer dynmic smpling
Goto Forum:
  


Current Time: Thu May 28 04:03:46 CDT 2020