Golden gate replicat issue

Posted by Arsalan on Feb 05, 2018; 7:22am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Golden-gate-replicat-issue-tp5130.html


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 ;