Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.