I want to use the redundancy analysis feature of TOP to compare foreign keys to primary keys. However the Oracle database I am analysing has the tables to be compared under different schemas. I found that redundancy analysis only works for tables within the same Oracle schema. Can you please confirm that this is indeed the case and whether there are any plans to extend TOP to support table comparison across different schemas.
Appreciate your help.