There is a simple solution to this. Look into a tool called ERWin. This tool has a feature which allows you to reverse engineer a number of different databases into a physical picture that will allow you to see the inter-relationships between all of your tables.
Well any CASE tools does what you want, itīs the minimum feature for a CASE tool
If you want to use trial products you could use Embarcadero ER Studio, ErWin
If you want o use a *free* one and powerful Oracle Designer, FREE if you dont use it for commercial use and because it does NOT expire
I have Oracle Designer Case Dictionary CD and also 2 CD's for Oracle Designer release 6 one of them is a pre configured repository. What is the mail difference between release 6 ,pre configured repository and cas dictionary.
Also how does oracle designer perform viz a viz other tools available. I have used ER Studio and it seems to be a decent tool.