My Oracle Support Banner

XSTREAMS CAPTURE DOES NOT CAPTURE BFILE TYPE AND XSTREAM FAILED WITH WRONG COLUMN DATA TYPE, COLUMN: 1, TYPE = 114 (Doc ID 2867276.1)

Last updated on MAY 05, 2022

Applies to:

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

Symptoms

As per the Oracle 19c documentation, Oracle XStream supports BFILE type. We have done a test below, and XStream Java API does not capture column data for BFILE type.

Oracle 19c documentation : https://docs.oracle.com/en/database/oracle/oracle-database/19/xstrm/xstream-out-concepts.html#GUID-19C316B4-C3B1-4C57-9CC7-E60FD728EC40

Imp:- Please note that we are observing the issue with Oracle XStream CAPTURE only. We are not using APPLY.




Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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