ERROR   OGG-01028 和 Compression is not supported

那么B_ORGANIZATION 表是 compression 是DISABLED .

仔細(xì)查找找到原因

1、alter table ... modify partition ... compress ... ，該方法僅適用于新插入的數(shù)據(jù)。

2、alter table ... move partition ... compress ... ，該方法適用于新插入的數(shù)據(jù)和已存在的數(shù)據(jù)。

當(dāng)時對壓縮表做了解壓縮，我用的第1種modify方式 解壓縮。也就說當(dāng)前程序?qū)Ρ鞡_ORGANIZATION中AAAX05AAOAAGfocAAH 這一行數(shù)據(jù)做了重新編輯，這樣就會出現(xiàn)OOG-01028錯誤現(xiàn)象。如下是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. 

如果是分區(qū)表請用

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

如果表的segment 比較大，要先確保有足夠空間。

完成之后再對表進(jìn)行重新同步。