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

    custom report to find cross schema dependencies in oracle db

    balvey

      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?