Data Compare for Oracle – BINARY_DOUBLE Type Support

Data Compare for Oracle – BINARY_DOUBLE Type Support

When using dbForge Data Compare for Oracle, it's important to understand limitations related to specific Oracle data types, especially when operating in Direct mode. Some Oracle data types are not fully supported in this mode, including:
  1. BINARY_DOUBLE
  2. BINARY_FLOAT
  3. XMLTYPE
This limitation is documented in the Type Compatibility Table and is common across various oracle developer tools.

Idea
Recommended Solution

If you encounter issues with these types, switch the connection from Direct mode to Client mode and run the comparison again.

This will ensure full support for BINARY_DOUBLE, BINARY_FLOAT, and XMLTYPE during data comparison.