Striim 3.9.7 documentation

OracleReader data type support and correspondence

Oracle type

TQL type

ADT

unsupported

ARRAY

unsupported

BFILE

unsupported

BINARY_DOUBLE

double

BINARY_FLOAT

float

BFILE

unsupported

BLOB

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

In Oracle 12c, an insert containing a column of this type generates two CDC log entries, an insert followed by an update. In Oracle 11g, it generates only a single update entry.

CHAR

string

CLOB

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

In Oracle 12c, an insert containing a column of this type generates two CDC log entries, an insert followed by an update. In Oracle 11g, it generates only a single update entry.

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

unsupported

NUMBER

string

NVARCHAR2

string

RAW

string

REF

unsupported

ROWID

unsupported

TIMESTAMP

DateTime

TIMESTAMP WITHLOCALTIMEZONE

DateTime (supported in LogMiner only)

TIMESTAMP WITHTIMEZONE

DateTime (supported in LogMiner only)

UDT

unsupported

UROWID

unsupported

VARCHAR2

string

VARRAY

unsupported

XMLTYPE

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.

If a table contains a column of a type that LogMiner does not support, LogMiner will not capture any data for the table. For more information, see http://docs.oracle.com/cd/E11882_01/server.112/e22490/logminer.htm#i1031090.