TABLE WITH NOLOGGING CAUSES EXTRACT TO ABEND EVEN WITH FORCED LOGGING ENABLED: OGG-00663 OCI Error retrieving bind info for query (status = 100) (Doc ID 1489900.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Extract abends on a table that has nologging, but database has force_logging enabled:

2012-08-30 15:13:49  ERROR   OGG-00663  OCI Error retrieving bind info for query (status = 100), SQL < select      (select count(*) from dba_tables where logging = 'NO'       and owner = 'D2PROD' and table_name = 'DD_CART_ITEM')     +      (select count(*) from dba_tab_partitions       where table_owner = 'D2PROD' and table_name = 'DD_CART_ITEM'       and logging = 'NO')     +      (select count(*) from dba_tab_subpartitions       where table_owner = 'D2PROD' and table_name = 'DD_CART_ITEM'       and logging = 'NO')    from DUAL >.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms