Just upgraded from v11.0 to v11.5.1. In v11.0, the Database | Compare | Data feature could be used for tables that did not have primary keys and had duplicate records. It would compare them without any problems. In v11.5, this is no longer possible. In v11.5.1, it says there is no primary key on the table and it does not allow to proceed. Why is this no longer possible to do? Is this by design or is it a defect?
This is by design.
Although, in 11.0 it worked that way, this type of results should not have been generated.
If one wants to sync two tables, one wants ALL rows. If one does not have all rows, then the row count will be off after the sync.
One wants the same number of records in the target table as in the source table, unless one specifies only which records to move.
This is not a defect.
The usefulness of having an 'option' to eliminate duplicates can be discussed further, but that would be an enhancement request.
Submit an enhancement request out on the Toad Idea Pond . Voting results will be considered in a future release of Toad for Oracle.