Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Script for dependencies.
I was wondering if anyone has a script to identify all dependencies between objects, for a particular user schema? I have looked at IDEPTREE, but it appears to identify dependencies for individual objects, not all objects owned by a user. I would like to recompile packages, procedures, etc... for a user, but I do not know the correct order.
Thank you,
Laurie.
-- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Laurie D. Miller Stanford University Database Administrator lmiller_at_lindy.stanford.eduReceived on Mon Apr 14 1997 - 00:00:00 CDT