Re: Recompile Invalid Objects - The Ultimate Solution
Date: Sun, 15 Dec 2002 23:56:20 -0800
Message-ID: <3DFD8724.71A68DB1_at_exesolutions.com>
FC wrote:
> "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,
> 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.
>
> If I manually validate those objects later on, they become valid.
> I think it depends on the order the program recompiles the objects.
>
> 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.
>
> The objects that are most likely in an invalid state in my case, are views
> containing user-defined packaged functions.
>
> 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.
>
> 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
Have it your way ... but please don't spam.
Dan Morgan Received on Mon Dec 16 2002 - 08:56:20 CET