Recompiling objects in oracle

A pl/sql script to recompile all invalid objects in oracle. Simple but powerfull.

Source:
http://www.orafaq.com/usenet/comp.databases.oracle.misc/2005/02/15/0382.htmy

Oracle reverse engineering

To reverse engineere the oracle database, you can use the Oracle data dictionary like follows.