My initial compare between 2 tables showed differences on all the tables’ VARCHAR2 columns, e.g. VARCHAR2(10) vs. VARCHAR2(10 BYTE) -.
I did a compare of another set of tables - no differences.
Went back to my original 2 tables, Spooling the SQL to Screen (I was curious what was causing the diffs) - no differences.
To reproduce, I disconnect from target db, rt-click source table -> Compare with another object, target object - connect to target db, choose correct schema, Compare - shows the BYTE differences.
Compare a 2nd time - no differences.