How to find out the referencing between the schemas?
560818Jul 26 2007 — edited Aug 1 2007Hi.
I have a database with several different schema's, each schema has each own application that run against it.but it's possible there are cross referencing among different schema.
Now I need to move some of the schema's to another database, can someone tell me that other then a export/import, what else I need to pay attention to? How do I find out from database dictionary if schema A uses schema B's tables or views ? Since some schema are going to be in a different database, if there are cross referencing between A and B, now A is in different DB then B, so I need to create a DB link, right, then how can make sure application still works without making change to application?
thanks in advance!