OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs

I got ” OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs ” error in the Oracle Goldengate.

 

OGG-01433 Failed to validate table. The table is compressed and extract will not be able to extract data from Oracle logs

Details of error are as follows.

The extract abended with OGG-01433

2011-05-26 08:49:48 ERROR OGG-01433 Oracle GoldenGate Capture for Oracle, EXXX.prm: Failed to validate table <SCHEMANAME.TABLENAME>. The table is compressed and extract will not be able to extract data from Oracle logs.
2011-05-26 08:49:48 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, EXXX.prm: PROCESS ABENDING.
: [/goldengate/product/GG19cFor18cDB/extract()]

2021-11-20 20:03:21 ERROR OGG-01433 Failed to validate table MSDB.TEST_TABLE. The table is compressed and extract will not be able to extract data from Oracle logs.

 

 

OGG does not support compressed tables or partitions prior to 11.2 Integrated Extract.

Oracle GoldenGate fully supports basic, advanced, and EHCC compressed tables in integrated capture (11.2) mode. In classic capture mode, Oracle GoldenGate can deliver to, but not capture from, regular and EHCC compressed tables on Oracle Exadata.

 

 

– Check if the table is compressed:

SQL> select compression from dba_tables
where owner = ‘<owner>’ and table_name = ‘<tablename>’;

Even if the query returns DISABLED, if any block in the table was ever compressed, EXTRACT will not be able to capture it.

– You can move the table. This will touch every block, but this will be very resource intensive for a large table and require a lot of disk:

SQL> SELECT partition_name, subpartition_name, tablespace_name, high_value FROM user_tab_subpartitions WHERE table_name = ‘table_name’;

– Alter statement for partition to move nocompress.

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

– Please ensure that you are having enough disk space within tablespaces before running the ALTER statement.

The only option is to comment out the compressed table to exclude them from EXTRACT if you can’t do a “move nocompress”DDL EXCLUDE OBJNAME

Once you find the table name, you have to exclude this table from both DDL and DML in Extract parameter file by using DDL EXCLUDE and TABLEEXCLUDE.

Example

DDL EXCLUDE OBJNAME “OWNER.TABLE_NAME”

TABLEEXCLUDE OWNER.TABLE_NAME

 

To solve this error, uncompress this table.

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 68,613 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply