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.
    • Related Articles

    • Timestamps Not in Expected Timezone in dbForge Studio for Oracle

      If you're encountering timestamps that don't match your system's timezone in dbForge Studio for Oracle, this can typically be resolved with a quick configuration update. This issue may arise due to default formatting settings or discrepancies in how ...
    • "Cannot obtain Oracle Client information from registry" Error

      The error message "Cannot obtain Oracle Client information from registry" when working with Oracle typically indicates that either the Oracle Client is not installed on your system, or there is a mismatch in the bitness between your application and ...
    • Loading Data from Excel

      This article is for Excel Add-ins. Excel Add-ins can be used to work with external data sources and update data directly in Excel. A common question is whether it is possible to load arbitrary data from an Excel worksheet into a connected database or ...
    • Guide: Configuring ODBC Driver in Azure Data Factory

      This guide walks you through the steps of setting up and using an ODBC driver in Azure Data Factory (ADF) for seamless data integration. By following this guide, you will be able to configure an ODBC driver, create a Linked Service, and define an ...
    • Missing Timestamp for a Comparison Execution

      If you're looking to track when a comparison was executed in dbForge Data Compare for PostgreSQL, note that there is no dedicated timestamp log for each operation. However, there is a related setting that can help: You can enable automatic restore ...