10 Replies Latest reply: Dec 2, 2012 10:14 AM by sb92075 RSS

    comparing index and PK of a table between instances

    TheHades0210
      Aloha!

      I am about to compare Indexes and PK's(Constraint) of 3 instances.

      What DBA table/s should i use best? The comparison is done to a specific schema only.

      Please be kind to numerate the tables or script that i need.

      PS
      Which is better dba_ind_columns or dba_objects?

      BR,
      Hades

      Edited by: TheHades0210 on Dec 2, 2012 9:58 PM