I am using Oracle SQL Developer's database diff tool to compare schemas. (SQL developer version : 3.2.09) It works great on some environments, but in one, I can only see differences in tables – the sequences and indexes are all treated as if they are new and not compared against existing ones.
I've confirmed the indexes exist in the target environment, and that my user account should have permission to see them – I have both "select any dictionary" system privilege and the "select_catalog_role" role. Further, I do see the indexes if I explicitly query "all_indexes" and "all_ind_columns" tables.
Any ideas what permissions I might be missing? Again, this works on another environment.