Re: Recompile Invalid Objects - The Ultimate Solution

[Quoted] "DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3DFC0EA6.FFE06BA0_at_exesolutions.com...
> "dr. Matteo Vitturi" wrote:
>
> > > 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.
>
> And you will absolutely guarantee that your product does? In all versions
> and editions?
>
> I've been working in Oracle as a DBA, developer, and instructor for more
> than 10 years and I've yet to have a single failure.
>
> That would put the value of a commercial product, to me, at about $0.00
> USD.
>
> But I invite anyone else to consider buying this product if you've ever
> experienced a failure and you can obtain an absolute guarantee from this
> vendor.
>
> Meanwhile ... this is still SPAM and does not belong in this usenet group.
> Please post all future marketing and public relations related postings to
> the appropriate group.
>
> Daniel Morgan
>

Daniel,
[Quoted] I know that Oracle provides a procedure (dbms_utility.compile_schema), but I noticed that sometimes you end up with some objects still in a invalid state.
I am talking win2000 8.1.7.0.0-wise.

[Quoted] If I manually validate those objects later on, they become valid. I think it depends on the order the program recompiles the objects.

[Quoted] I also wrote a program using a hierarchical query doing the same job as Mat's one, but in the end, the objects get validated as soon as they are invoked, so, unless you absolutely need to start off with all the objects in a valid state, it is not strictly necessary to use such program.

[Quoted] The objects that are most likely in an invalid state in my case, are views containing user-defined packaged functions.

[Quoted] While I agree on the fact that Oracle automatically recompiles the objects in the dependency tree in the correct order, I am not 100% sure that the packaged procedure goes through the objects in the given schema according to a hiearchical order.

[Quoted] But even if this is true in certain cases, I don't think the value of Oracle is affected in any way.
In the end the object you call will be validated and, if not, it won't be Oracle's fault.

Bye,
Flavio Received on Sun Dec 15 2002 - 12:50:36 CET