Streams Capture Failing With ORA-26744 And ORA-26766 (Doc ID 1112544.1)
Last updated on JANUARY 24, 2013
OracleDatabase - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2] Information in this document applies to any platform.
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
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;
select col#, segcol#, name, property from sys.col$ where obj# = (select obj# from sys.obj$ where name = '&TABLE');
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';
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