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? 🙂
It always amazes me how many Unix people do not know about the command: apropos. It’s fabulous! Using apropos has allowed me learn many things about unix and linux that I would not have discovered otherwise. You can spend a lot of time with it, and learn heaps.