6 Replies Latest reply on Apr 28, 2016 11:45 AM by balvey

    custom report to find cross schema dependencies in oracle db


      We are attempting to decouple our applications and I've been tasked with finding dependencies between schemas. I've queried dba_dependencies to find all occurences where views, synonyms, etc cross schemas, but I don't have auditing turned on to determine where os users are running sql against multiple schemas. I believe the data should exist within the ignite repository, or at least a sibilance of that data enough to where I could make some safe assumptions. What tables / columns should I be looking at to get that information?