DBA_DEPENDENCIES

Oracle 11gR1

DBA_DEPENDENCIES describes all dependencies in the database between procedures, packages, functions, package bodies, and triggers, including dependencies on views created without any database links. Its columns are the same as those in ALL_DEPENDENCIES.

Related Views

· ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database links. This view does not display the SCHEMAID column.

· USER_DEPENDENCIES describes dependencies between objects in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
TYPE	VARCHAR2(17)		Type of the object
REFERENCED_OWNER	VARCHAR2(30)		Owner of the referenced object (remote owner if remote object)
REFERENCED_NAME	VARCHAR2(64)		Name of the referenced object
REFERENCED_TYPE	VARCHAR2(17)		Type of the referenced object
REFERENCED_LINK_NAME	VARCHAR2(128)		Name of the link to the parent object (if remote)
SCHEMAID	NUMBER		ID of the current schema
DEPENDENCY_TYPE	VARCHAR2(4)		Indicates whether the dependency is a REF dependency (REF) or not (HARD)

Note:

1.

select * from DBA_DEPENDENCIES where owner = 'CSMIG';

OWNER	NAME	TYPE	REFERENCED_ OWNER	REFERENCED_ NAME	REFERENCED_ TYPE	REFERENCED_ LINK_NAME	DEPENDENCY_ TYPE
CSMIG	CSMV$TRIGGERS	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$TABLES	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$INDEXES	VIEW	SYS	USER$	TABLE		HARD
CSMIG	CSMV$INDEXES	VIEW	CSMIG	CSM$INDEXES	TABLE		HARD
CSMIG	CSMV$TABLES	VIEW	CSMIG	CSM$TABLES	TABLE		HARD
CSMIG	CSMV$TRIGGERS	VIEW	CSMIG	CSM$TRIGGERS	TABLE		HARD

Oracle data dictionary views