Invalid objects? Here are some scripts to recompile them.
Here is a script I’ve used to quickly hunt down objects and information about them. Very useful to find things like: exact spellings, other objects with a similar spelling, or owned by a different user, synonyms, etc.
Script to find all generations Of an object’s children. Children. Grandchildren. Great-Grandchildren. Great-Great-Grandchildren. Etc.
What if some of your objects require parent objects 10 layers deep first? ie: type, table, function, view, synonym, package, procedure, etc. All_Dependencies only goes one layer deep.
Here is a very complex script to find all the successive parents of an object.
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.
After discovering so many tables that no primary key, at so many shops, I finally wrote an Oracle script to list all the tables that did not have a PK.