Search notes:

$ORACLE_HOME/rdbms/admin/utldtree.sql

utldtree.sql creates object that can be used to show dependencies between objects.

The objects created are:

`deptree_fill`	The procedure that collects dependency information.
`deptree_temptab`	The table that stores the collected dependency data.
`deptree`	A view that select from `deptree_temptab` (and, if created by `sys`, also from the fixed tables `x$kgldp`, `x$kglob`, `x$kglxs` to show cursors that depend on the given object)
`ideptree`	A view that selects from `deptree` and shows the data somewhat more prettier.
`deptree_seq`	The sequence that provides the primary key values for `deptree_temptab`.

Install the objects in SQL*Plus:

SQL> @ ?rdbms/admin/utldtree.sql

-- exec deptree_fill(type => 'view'     , schema => user, name => 'ideptree')
-- exec deptree_fill(type => 'view'     , schema => user, name => 'deptree')
-- exec deptree_fill(type => 'view'     , schema => user, name => 'deptree')
-- exec deptree_fill(type => 'procedure', schema => user, name => 'deptree_fill')
   exec deptree_fill(type => 'table'    , schema => user, name => 'deptree_temptab')

select * from ideptree;
select * from deptree          order by seq#;
select * from deptree_temptab  order by seq#;

Misc

This file was renamed from utldeptree.sql to utldtree.sql in 1992.

The view ideptree has a group by clause for which a comment states as reason So user can omit sort-by when selecting from ideptree.

Kim Berg Hansen thinks this was originally intended as order by.

$ORACLE_HOME/rdbms/admin/utldtree.sql

Misc

See also