My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.