Evaluate Consulting Services

My technical blog is listed in Top 100 Oracle Blogs And Websites To Follow in 2021


Here I am giving an example to find where specific table or view is used in oracle database Query 1: All objects where specific table or view accessible to the current user is used in Oracle database. SELECT  referenced_owner        ||  ‘.’        || referenced_name  AS  table_name ,        referenced_type     AS   TYPE ,         owner        ||  ‘.’        ||  NAME   AS  referencing_object ,         TYPE      AS  referencing_type    FROM  sys . all_dependencies   WHERE  referenced_type  IN   ( ‘TABLE’ ,   ‘VIEW’ )     AND  referenced_name    =  ‘FXGN_USERS’   — put your table/view name here     –AND referenced_owner = ‘SCHEMA_NAME’     AND   owner   NOT   IN   ( ‘ANONYMOUS’ , ‘CTXSYS’ , ‘DBSNMP’ , ‘EXFSYS’ ,                         ‘MDSYS’ ,   ‘MGMT_VIEW’ , ‘OLAPSYS’ , ‘OWBSYS’ ,                       ‘ORDPLUGINS’ ,   ‘ORDSYS’ ,   ‘SI_INFORMTN_SCHEMA

Leave a Comment

Your email address will not be published. Required fields are marked *