Streams Capture Failing With ORA-26744 And ORA-26766 (Doc ID 1112544.1)

Last updated on JANUARY 24, 2013

Applies to:

OracleDatabase - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

Issue happens when using a local or downstream Streams Capture, Change Data Capture (CDC) or Logical Standby / DataGuard.

Capture fails with following errors at alert log and trace files:

ORA-26744: STREAMS capture process "<capture name>" does not support "<table owner>"."<table name>" because of the following reason:
ORA-26766: Unexpected redo pattern encountered by LogMiner

Changes

There is a column added to the table with a non-null default value.

You can also check to see if you are hitting this issue if the table in question has the 0x40000000 bit (decimal 1073741824 ) set in sys.col$.property for a column in the table. Use below queries to retrieve such information:

select col#, segcol#, name, property from sys.col$ where property = 1073741824;

or

select col#, segcol#, name, property from sys.col$ where obj# = (select obj# from sys.obj$ where name = '&TABLE');

or

select a.col#, a.segcol#, a.name from sys.col$ a, sys.tab$ b, dba_objects c where c.object_id=b.obj# and c.object_id=a.obj# and a.property = 1073741824 and owner = '&OWNER' and object_name = '&TABLE';

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