|
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 ;
|