Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba dependencies

Find out dependencies from 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>