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

Find out dependencies from dba_dependencies

   <source lang="sql">

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></source>