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.
Notes on Oracle’s solution to find object dependencies, DEPTREE. Written in 1991, and still included on installation.
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.
The installation guide for Oracle Applications R12 is 150 pages long! And it still requires a lot of searching the web to get the install right. Here is a concise overview of the install, what you really need to know, in about 1000 words.
If you work with Oracle Applications R12, you know that there are a few TOPs, such as APPL_TOP, COMMON_TOP, etc. But I have been able to detail over 200 TOPs!
Commands To Show The Linux Version. Let the count the ways.
Can’t get the command, domainname to work? Here is the secret.
Math Joke. Do You Get It? 🙂