Streams Capture aborts with Ora-26752 for CLOB datatype. (Doc ID 344424.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.4 and later
Information in this document applies to any platform.

Symptoms

In a Streams replication setup there is a table which has a LOB (Large Object Datatype) e.g. CLOB.

When capture process is started , it aborts and generates a trace as follows:

*** SERVICE NAME:(SYS$USERS) 2005-11-22 23:00:01.305
*** SESSION ID:(277.38823) 2005-11-22 23:00:01.305
ORA-26752:SCOTT:VRT_SAVED_QUERY
++ LCR Dump Begin: 0x19011ed18
operation: 255, baseobjn: 45117, objn: 45117, objv: 1,
DFlag: 0x80003, MFlag: 0x240000, PFlag: 0x00,
iotPrimaryKeyCount: 0x0, MergeFlag: 0x3,
Id : 1 numChgRec = 0
RedoThread# = 1, rba: 0x0002a7.00012335.0088
scn: 0x0001.bbaea05e
xid: 0x0003.023.000013b1
newcount = 0, oldcount = 0
LUBA: 0x2.802c2f.23.37.b03e
error 26752 in STREAMS process
ORA-26752: Unsupported LCR received for "SCOTT"."VRT_SAVED_QUERY"
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-26752: Unsupported LCR received for "SCOTT"."EMP"

Sometime ORA-26744 and ORA-26773 errors may be raised for this issue.

Changes

Added a table with CLOB datatype.

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