Oracle has a great table that will give you some great meta data about your other tables and columns called “all_tab_cols“.
1 2 3 4 5 |
select Table_name, Column_name, Data_type, High_value, low_value from all_tab_cols order by table_name desc |
I have only included 5 of what I think are the most important columns but there are lots of others you might need to do a “Select *” and see what you get
But that is only the beginning then you should export those results and pivot them in Excel and this will give you a list of columns and what tables they have in common.