table_dep.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Table_Dep.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays a list dependencies for the specified table.
--* Requirements : Access to the ALL views.
--* Call Syntax  : @Table_Dep (table-name) (schema-name)
--* Last Modified: 15/07/2000
PROMPT
SET VERIFY OFF
SET FEEDBACK OFF
SET LINESIZE 255
SET PAGESIZE 1000


SELECT ad.referenced_name "Object",
       ad.name "Ref Object",
       ad.type "Type",
       Substr(ad.referenced_owner,1,10) "Ref Owner",
       Substr(ad.referenced_link_name,1,20) "Ref Link Name"
FROM   all_dependencies ad
WHERE  ad.referenced_name = Upper('&&1')
AND    ad.owner           = Upper('&&2')
ORDER BY 1,2,3;

SET VERIFY ON
SET FEEDBACK ON
SET PAGESIZE 14
PROMPT