Very Useful Scripts To Find Object Dependencies

Very Useful Scripts To Find Oracle Object Dependencies; Parents, and Children.

Fabulous to determine:
– The order of operations to create objects. Parents first. Then children.
– The impact of dropping a view, package, procedure.
– Causes of object invalidation such as another invalid object.
– ALL the tables that a package is accessing.
– Whether a package, function or procedure calls another prodecure.
– Obscure issues, such as references to variables in packages.

Continue Reading →