Using COMPARE DATA in 25.1 we have good results. Only the diferences are showed but now in 25.3 we execute the same comparison and we receive all lines as NOT EQUAL and the suggestion is to delete all lines and insert again.

Hi Luishmr, There were very few changes to compare data from 25.1 to 25.3 so I'm not sure what the problem could be. I haven't heard any problem reports from that window. It sounds like maybe 25.3 didn't find a primary key between the tables and 25.1 did. Please check that and let me know. I…

Hi John, I have the same schema, same table in 2 different ORACLE instances. 2 different hardware. Comparing in 25.3 [image] Result are: [image] Comparing now exact the same instances, hardware and table. BUT NOW IN 25.1 [image] [image] [image]

TOAD_COMPARE_DATA_TABLE_DEFINITION.txt (67.0 KB)

Proposed Sync Script_in_25_3.sql (95.2 KB)

Thank you for the details. I can reproduce it and will get to the bottom of it soon.

Hi Luishmr, This problem happens when all of the following are true: You are comparing Tables, Views, or MViews The primary key of the table contains a mix of VARCHAR2 and non-varchar2 datatypes. The tables are in different databases and you are not using a DB Link in the comparison So, if you a…

Thank you very much John. Appreciate it. The comparison tool is very useful here in my company. Luis H> =-=-=-=-=-=-=-=-=-==

TOAD ORACLE 25.3 - COMPARE DATA is not working properly

Toad for Oracle & DevOps Toolkit

JohnDorlon December 9, 2025, 1:16pm 9

You're welcome. I'm sorry that I broke it.

I hope you can use the beta at your company so that you don't have to rely on the workarounds. You can get the beta here.

Topic		Replies	Views
Null fields not getting compared using using data compare option of Toad for Oracle Toad for Oracle & DevOps Toolkit	14	3383	October 9, 2017
Problem with data compare Toad Data Point & Toad Intelligence Central	6	374	January 18, 2011
Data compare issue? Toad for SQL Server	3	39	June 2, 2026
Data compare between two databases using Data Point Toad Data Point & Toad Intelligence Central	17	4470	August 7, 2018
Single Data Compare with no DB Link Toad for Oracle - Beta	6	1196	July 2, 2020

TOAD ORACLE 25.3 - COMPARE DATA is not working properly

Related topics