ERROR OGG-01028 和 Compression is not supported

那么B_ORGANIZATION 表是 compression 是DISABLED .

仔细查找找到原因

1、alter table ... modify partition ... compress ... ，该方法仅适用于新插入的数据。

2、alter table ... move partition ... compress ... ，该方法适用于新插入的数据和已存在的数据。

当时对压缩表做了解压缩，我用的第1种modify方式 解压缩。也就说当前程序对表B_ORGANIZATION中AAAX05AAOAAGfocAAH 这一行数据做了重新编辑，这样就会出现OOG-01028错误现象。如下是oracle的解决方法：

However, due to bug 10063108, sometimes the error message on compressed tables are not entirely correct. This problem has been fixed in 11.1.1.0.3 and above 

A table created as compressed will cause all of the DMLas to go into compressed blocks on disk. If the user does an "alter table nocompress", every DML that goes into the table AFTER that point in time will be uncompressed. The query for compression will return "nocompress" now, but that simple "alter" does not change the already existing compressed blocks on disk that were created before the "alter". So to capture the records from a table which was compressed we need to do the following 

sql> alter table <tablename> move nocompress; 

This will touch every single block on disk and will uncompress everything and so OGG should be all good. 

如果是分区表请用

SQL> ALTER TABLE <Table_name> MOVE PARTITION <partition_name> NOCOMPRESS TABLESPACE <tablespace>; 

如果表的segment 比较大，要先确保有足够空间。

完成之后再对表进行重新同步。