Re: Recompile Invalid Objects - The Ultimate Solution
From: dr. Matteo Vitturi <matteo_vitturi_at_yahoo.com>
Date: 14 Dec 2002 04:29:00 -0800
Message-ID: <9d3bb42b.0212140429.461d7783_at_posting.google.com>
Date: 14 Dec 2002 04:29:00 -0800
Message-ID: <9d3bb42b.0212140429.461d7783_at_posting.google.com>
> I presume you think Oracle did not include a built-in package in every
> installed database to do this?
> Fascinating.
> Dan Morgan
I presume you think such built-in package *works* in all cases... well
it is not true.
I found dbms_utility.compile_schema(schema) simply every so often
*fails* to recompile the invalid object in the *correct* order...
Regards.
Mat.
Received on Sat Dec 14 2002 - 13:29:00 CET