Striim 3.10.2 documentation

Table of Contents

Oracle Reader data type support and correspondence

If a table contains a column of a type not supported by LogMiner, LogMiner will not capture any data for the table. For more information, see "Unsupported Data Types and Table Storage Attributes" in the LogMiner documentation for your version of Oracle.

Oracle type

TQL type

ADT

not supported by LogMiner

ARRAY

not supported by Oracle Reader

BFILE

not supported by LogMiner

BINARY_DOUBLE

double

BINARY_FLOAT

float

BFILE

not supported by Oracle Reader

BLOB

string (a primary or unique key must exist on the table)

An insert or update containing a column of this type generates two CDC log entries: an insert or update in which the value for this column is null, followed by an update including the value.

CHAR

string

CLOB

string (a primary or unique key must exist on the table)

An insert or update containing a column of this type generates two CDC log entries: an insert or update in which the value for this column is null, followed by an update including the value.

DATE

DateTime

FLOAT

string

INTERVALDAYTOSECOND

string (when using LogMiner, string always has a sign; when using XStream, string begins with minus sign if value is negative, but the plus sign is omitted for positive values)

INTERVALYEARTOMONTH

string (when using LogMiner, string always has a sign; when using XStream, string begins with minus sign if value is negative, but the plus sign is omitted for positive values)

LONG

Results may be inconsistent. Oracle recommends using CLOB instead.

LONG RAW

Results may be inconsistent. Oracle recommends using CLOB instead.

NCHAR

string

NCLOB

string (a primary or unique key must exist on the table)

NESTED TABLE

not supported by Oracle Reader

NUMBER

string

NVARCHAR2

string

RAW

string

REF

not supported by Oracle Reader

ROWID

not supported by Oracle Reader

TIMESTAMP

DateTime

TIMESTAMP WITHLOCALTIMEZONE

DateTime (supported in LogMiner only)

TIMESTAMP WITHTIMEZONE

DateTime (supported in LogMiner only)

UDT

not supported by Oracle Reader

UROWID

not supported by Oracle Reader

VARCHAR2

string

VARRAY

not supported by LogMiner

XMLTYPE

Supported only for Oracle 12c and later. When DictionaryMode is OnlineCatalog, values in any XMLType columns will be set to null. When DictionaryMode is OfflineCatalog, reading from tables containing XMLType columns is not supported.