SQL Script Object Dependencies

Updated: 24-Nov-2004
Version: 1.0

Description

This script lists all dependent objects.

Parameters

&1 - object name

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

rem Dependency Listing
rem 

CLEAR
SET HEAD ON
SET VERIFY OFF
set pages 100

spool depend.lst

ACCEPT obj PROMPT 'Enter Value For Object : '

define object_name = UPPER('&obj')

select   decode(referenced_type, 'NON-EXISTENT', '.....', referenced_type)
	 || ' ' || referenced_owner || '.' || referenced_name r_name,
	 '    is referenced by: ' || type || ' ' || owner || '.' || name name,
	 '    Referenced Link: ' || decode(referenced_link_name, null, 'none',
	 referenced_link_name) r_link
from     sys.dba_dependencies
where owner not in ('SYS', 'SYSTEM')
and referenced_name = &object_name
order by 1,2;


spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links