Known Issues for ExpressConnect for Oracle

ExpressConnect for Oracle does not support opaque datatypes.

The Replication Server opaque datatype is not supported by ExpressConnect for Oracle 15.7.1, which means that this version of ExpressConnect for Oracle cannot support user-defined datatypes and the Oracle anydata function.

Workaround: None.

ExpressConnect for Oracle fails when bulk copy is enabled and the bulk copy threshold is set to 1.

ExpressConnect for Oracle fails when you set dsi_bulk_copy to on and dsi_bulk_threshold to 1. Setting dsi_bulk_threshold to 1 deteriorates and suspends the Data Server Interface (DSI).

Workaround: Set dsi_bulk_threshold to 2 or higher.

LOB value not being applied to existing row.

When replicating an LOB column, ExpressConnect for Oracle first determines the ROWID value for the Oracle row that should contain the LOB. The row for that ROWID is updated with the LOB value. However, if the table in the replicate Oracle database is a reference table, and the parent table is partitioned across multiple tablespaces, then the ROWID returned for the reference table may be incorrect, resulting in the LOB value not being applied to the expected row. The Oracle bug ID for this incorrect ROWID problem is 8417690.

Workaround: None.