那么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 比較大，要先確保有足夠空間。

完成之后再對表進行重新同步。