显示procedures, packages, functions, package bodies, and triggers 和基于非dblink的视图 的 依赖性。 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".

举例：

create view GDBMZD
as
SELECT KCBMZD_BMBH AS GDBMZD_BMBH , KCBMZD_BMMC AS GDBMZD_BMMC,
KCBMZD_JS AS GDBMZD_JS, KCBMZD_MX AS GDBMZD_MX,KCBMZD_DH AS GDBMZD_NOTE
FROM KCBMZD
/

然后去DBA_DEPENDENCIES查询，如下的结果：

	OWNER	NAME	TYPE	REFERENCED_OWNER	REFERENCED_NAME	REFERENCED_TYPE	REFERENCED_LINK_NAME	DEPENDENCY_TYPE
1	LC0049999	GDBMZD	VIEW	LC0049999	KCBMZD	TABLE		HARD

[@more@]

ITPub博客

DBA_DEPENDENCIES 视图

最新文章