Streams Capture aborts with Ora-26752 for CLOB datatype.
(Doc ID 344424.1)
Last updated on FEBRUARY 08, 2017
Oracle Database - Enterprise Edition - Version 10.1.0.4 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
newcount = 0, oldcount = 0
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.
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