Find out dependencies from dba_dependencies : dba_dependencies « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. dba_dependencies

SQL> --
SQL>
SQL>
SQL> BREAK ON    r_name SKIP 1
SQL> COLUMN      r_name FORMAT a80
SQL> COLUMN      name FORMAT a80
SQL> COLUMN      r_link FORMAT a80
SQL> SET HEADING OFF
SQL> SELECT  DECODE(referenced_type, 'NON-EXISTENT', '.....',
  2          referenced_type) || ' ' || referenced_owner ||
  3          '.' || referenced_name r_name, '    is referenced by: ' ||
  4          type || ' ' || owner || '.' || name name,
  5          '    Referenced Link: ' || DECODE(referenced_link_name,
  6          NULL, 'none', referenced_link_name) r_link
  7  FROM    dba_dependencies
  8  WHERE   owner NOT IN ('SYS', 'SYSTEM')
  9  and     rownum < 50
 10  ORDER BY 1,2;

TABLE SYS.CCOL$
    is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS
    Referenced Link: none


TABLE SYS.COL$
    is referenced by: PACKAGE BODY CTXSYS.DRICON
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIREPZ
    Referenced Link: none


TABLE SYS.COL$
    is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS
    Referenced Link: none


TABLE SYS.CON$
    is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS
    Referenced Link: none


TABLE SYS.ICOL$
    is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS
    Referenced Link: none



TABLE SYS.IND$
    is referenced by: PACKAGE BODY CTXSYS.DRIREPZ
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIUTL
    Referenced Link: none


    is referenced by: PROCEDURE CTXSYS.DRI_MOVE_CTXSYS
    Referenced Link: none



TABLE SYS.TS$
    is referenced by: PACKAGE BODY CTXSYS.DRIREPZ
    Referenced Link: none


    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_XE_CONFIG
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: PACKAGE BODY CTXSYS.DRIACC

    Referenced Link: none

TABLE SYS.USER$
    is referenced by: PACKAGE BODY CTXSYS.DRICON
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIIXS
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIPREF
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: PACKAGE BODY CTXSYS.DRIREPZ
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRISGP
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRISPL
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: PACKAGE BODY CTXSYS.DRITHSC
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIUTL
    Referenced Link: none


    is referenced by: PACKAGE BODY CTXSYS.DRIVAL
    Referenced Link: none



    is referenced by: PACKAGE BODY CTXSYS.DRIXMD
    Referenced Link: none

TABLE SYS.USER$
    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_IMP_PARSER
    Referenced Link: none


    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_PROVISIONING
    Referenced Link: none


    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_SW_API

    Referenced Link: none

TABLE SYS.USER$
    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_THEME_FILES
    Referenced Link: none


    is referenced by: PACKAGE BODY FLOWS_020100.WWV_FLOW_XE_PROVISION
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_INDEXES
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_INDEX_ERRORS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_INDEX_OBJECTS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_INDEX_PARTITIONS
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_INDEX_SETS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_INDEX_SET_INDEXES
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_INDEX_SUB_LEXERS
    Referenced Link: none



    is referenced by: VIEW CTXSYS.CTX_INDEX_SUB_LEXER_VALUES
    Referenced Link: none

TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_INDEX_VALUES
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_PENDING
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_PREFERENCE_VALUES

    Referenced Link: none

TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_SECTIONS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_SECTION_GROUPS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_SQES
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_STOPLISTS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_STOPWORDS
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_SUB_LEXERS
    Referenced Link: none


TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_THESAURI
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_USER_INDEXES
    Referenced Link: none


    is referenced by: VIEW CTXSYS.CTX_USER_INDEX_PARTITIONS
    Referenced Link: none



    is referenced by: VIEW CTXSYS.CTX_USER_SQES
    Referenced Link: none

TABLE SYS.USER$
    is referenced by: VIEW CTXSYS.CTX_USER_SUB_LEXERS
    Referenced Link: none



49 rows selected.

SQL>