My Oracle Support Banner

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

Last updated on DECEMBER 11, 2019

Applies to:

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


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
++ 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.


Added a table with CLOB datatype.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.