Darn invalid objects dependencies!

I am attempting to script some data movement from 8.0.5 to 8.1.7. So I need a script that can recompile everything that it finds that is invalid. Naturally, I had a cute one pass called comp_all from metalink (having fixed its self-immolation qualities, of course), that used the order_object_by_dependency view. Of course, that has been taken away because of the wonderful java stuff, and the dbms_util package that is supposed to do it has bugs so it doesn't always validate everything, and 8.1.7 is the last 8i... "fixed in a future release" as I once posted in a rec.humor.funny posting.

So does anybody have a script that can do this, or do I go back to the old 7 way of a script that compiles everything invalid and just run it a bunch of times and hope for the best?

Metalink Note:121153.1 seems kind of... I don't know, hacked or something.

jg

--
You'd think they would have figured it out by now...