column "OBJ NAME" format a15
column type format a5
column "REF. OWNER" format a10
column referenced_name format a10
column "RTYPE" format a10
accept user PROMPT 'INGRESE OWNER: '
set pause mas...
set pagesize 24
set verify off
break on "OBJ NAME"
select name "OBJ NAME", type, REFERENCED_OWNER "REF. OWNER", referenced_name "RE
F. NAME", referenced_type "RTYPE"
from dba_dependencies
where owner like '&user'
and owner not in ('SYS','SYSTEM')
order by name, type
Received on Fri Jan 19 2001 - 07:25:25 CST
