I have to transfer a oracle 8i database to another machine.
Recreation of all tables/views/users ...
There is a problem this database acts as a reference DB, so other db's are connected and they have views/synonyms on this DB.
How can I see which table/views are used by other DB, without checking every DB?
So that I also can recreate these views/synonyms.