Type Compatibility Table

These tables demonstrate which data types can be compared by Data Compare for Oracle when you connect to the Oracle server in direct mode or with a client.

Connection mode: Direct

Data types conversion in direct connection

Connection mode: Client

Data types conversion in client connection

checkmark - can be compared

Empty cells - explicit conversion is performed when comparing. A synchronization script will contain already converted data. On the Different, Equal, and Only in Target tabs in the Data Comparison document, you will see data in Target data type, Only in source will display data in the Source data type.

! - possible data loss