This discussion is archived
10 Replies Latest reply: Dec 2, 2012 8:14 AM by sb92075 RSS

comparing index and PK of a table between instances

TheHades0210 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points