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 APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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.
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