Capture Fails With Ora-26744 Ora-26766 For Table with Single Column Xmltype Stored As Clob
Last updated on APRIL 28, 2009
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 18.104.22.168
This problem can occur on any platform.
Created table SCOTT.TAB2
create table tab2 (
XMLTYPE col1 store as CLOB;
Setup Streams for table SCOTT.TAB2
Upon DML CAPTURE aborts with message:
ORA-26744: STREAMS capture process "CYC3_CAPTURE" does not support "SCOTT".
"TAB2" because of the following reason:
ORA-26766: Unexpected redo pattern encountered by LogMiner
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms