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