Golden gate replicat issue

[Arsalan]

Hello sir,

I Configured oracle golden gate between oracle 11g and oracle 12c

but we have 6 tables which are already compress on prod db

i expdp/impdp from prod db in my test db, so i found some table which was compress

oracle golden gate not support compress table

I uncompress those table in test db when i start replicate that it does not replicate data

but other tables which was not compressed it replicate fine'

why those table not replicate data and even i uncompressed that

kindly guide me

Best regard


NOTE I USED TO UNCOMPRESS TABLE BY BELOW QUERY

SELECT table_name, compression, compress_for
FROM user_tables
where compression='ENABLED';

alter table INDIVIDUAL   move nocompress ;

[ErmanArslansOracleBlog]

What is written in GG logs?

[Arsalan]

Here is the logs.


ggserr.log

[ErmanArslansOracleBlog]

What is the name of that problematic table?

[Arsalan]

HI Arslan

Actually we 6 tables which was compress after uncompressed  still have problem.


INDIVIDUAL -- it have primary key and other tables does not have primary key it have foreign key
ENTERPRISE
TAX_ACCOUNT  
ASSESSMENT  

[ErmanArslansOracleBlog]

You have trigger related errors in the log file .(for the table named ENTERPRISE), please check them.

Other tables that you mentioned, however; are not recorded in the log file..

Did you actually configured GG for replicating them?